ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  SQL Subqueries
Subject:   i want a previous value of the max value
Date:   2005-01-31 20:33:08
From:   raviambala
i want a prevoius value of the max value
for example we have a table Employee
EmpId EmpName Salary
a001 Ravi 10000
a002 Amit 9500
a003 Chetan 15000
a004 Rahul 6500

the max of salary is 15000
in the above table i want the second max salary means 10000

1 to 3 of 3
1 to 3 of 3