Nth Largest element from a table sql Query

Posted by Binu on Stack Overflow See other posts from Stack Overflow or by Binu
Published on 2010-05-30T06:28:08Z Indexed on 2010/05/30 6:32 UTC
Read the original article Hit count: 206

SELECT a.ID
  FROM tblitem a
 WHERE (4) = (select count(*)
                from tblItem  b
               where b.id < a.id)

© Stack Overflow or respective owner