Thread: get the value of the 3rd row from bottom?
View Single Post
  #2 (permalink)  
Old 08-21-2006, 02:06 AM
Dimitar
 
Posts: n/a
Default SQL 92 answer. Re: get the value of the 3rd row from bottom?
[sql]
select min(a) from t where a > (select min(a) from t where a > (select min(a) from t));
[/sql]
What will the above return if the table was less than 3 in cardinality?
Reply With Quote