Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    AUS
    Posts
    26

    Unanswered: select using coulmn number

    hi all,
    is there any chance to select records using column i.d

    say SELECT (COLUMN i.d) FROM X; which gets the data's of the coumn number

    cheers

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi melb,

    Do you mean sorting the column1?
    SELECT COLUMN_id FROM X ORDER BY COLUMN_id;

    If needed descending order then write DESC at the end of the command:
    SELECT COLUMN_id FROM X ORDER BY COLUMN_id DESC;

    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Aug 2003
    Location
    AUS
    Posts
    26
    Hi Grofaty,
    Thanks for your reply ? I will ask the question in detail.

    example :
    Table a

    name address phone
    aaa aaaa 9999
    bbb bbbb 8888

    is there any command like using the column id instead of name.
    say
    SELECT columnid(1) from a;
    instead of
    SELECT address from a;

    cheers
    melb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •