How to find the second largest salary in the emp database and

Cristiana · #1 (**permalink**) 05-19-2008, 02:12 PM

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on in the emp database ?

Seemant · #2 (**permalink**) 06-14-2008, 02:21 PM

SELECT salary From emp_table e1
WHERE 1=(SELECT COUNT(*) From emp_table e2 WHERE e1.salary

replysunilsharma · #3 (**permalink**) 06-27-2008, 12:34 PM

SELECT TOTAL_AMOUNT FROM MONTHLY_BILL_DETAILS a
where 1=(SELECT count(*) FROM MONTHLY_BILL_DETAILS b where a.TOTAL_AMOUNT)

is not working show error at breackets

m/s invalid operator

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode