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

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

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