How
to select the first row of a table?
How can I select the first
row in a table...
I thought of doing.
select * from dbstruct where
recno=(select min(recno) from dbstruct)
but this invlove table scanning
which shouln't be necessary...
Ans:
select * from <table> where
rownum = 1;