Retrieving Top Most Row In A Table

[KeenEyeLearner]

Hi If i have a table [ named : TAB1 with columns C1,C2,C3 ] and i want to see the value of the first row only, what would be the query.I know that this works..--> select C1,C2,C3 from (select C1,C2,C3,rownum rn from TAB1) where rn<=1;But this is too long. I tried this, but it did not work. --> select top 1 from TAB1;Any help please......Thanks

[aspnetguy]

MSSQL

SELECT TOP 1 * FROM tablename

MySQL

SELECT * FROM tablename LIMIT 1

[Jack McKalling]

MySQL:

SELECT * FROM tablename ORDER BY indexcolumn LIMIT 1

[aspnetguy]

MySQL:

SELECT * FROM tablename ORDER BY indexcolumn LIMIT 1

<{POST_SNAPBACK}>

Doesn't it do that automatically if you don't specify an ORDER BY??? MSSQL does anyways.

[Jack McKalling]

In case you have a table with a custom index (a column containing unique alphanumeric characters)