Thread: how to find third highest record from table?
View Single Post
  #4 (permalink)  
Old 12-19-2006, 11:57 AM
Dhanalakshmi
 
Posts: n/a
Default SQL 99 answer. Re: how to find third highest record from table?
SELECT TOP 1 *
FROM (SELECT TOP 2*
FROM tablename
ORDER BY columnname DESC)e1
ORDER BY Sal
Reply With Quote