Thread: how to find second max
08-27-03, 02:08 #1Registered User
- Join Date
- Aug 2003
Unanswered: how to find second max
can any one help me in finding the SECOND MAXIMUM from a table..
let us consider i have a column for salary ..now i want to find the SECOND MAXIMUM salary in the table...can any one give the query in SQL...
Thanks in advance..