Thread
:
how can i select the third row from table?
View Single Post
#
2
(
permalink
)
08-21-2006, 02:04 AM
Dimitar
Posts: n/a
SQL 92
answer.
Re: how can i select the third row from table?
[sql]
select max(a) from t where a < (select max(a) from t where a < (select max(a) from t));
[/sql]
What will the above return if the table is less than 3 in cardinality?
Dimitar
SQL 92