how to check the 3rd max salary from an employee table?

Answer Posted / pavan ranga

select top 1 (salary),Name from customers
where salary not in (Select top 2 (Salary) from customers)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I save the results of sql query in a file?

620


What is PL/SQL Records?

721


Why are indexes and views important to an organization?

602


What are the benefits of stored procedures?

608


Why we use triggers in mysql?

640






What is package in pl sql with an examples?

629


What is rownum and rowid?

656


Is sql easier than java?

627


What are the types pl/sql code blocks?

700


What is data definition language?

705


Does varchar need length?

612


How is sql used in oracle?

669


What is difference between table and view?

612


How do you determine the current isolation level? : Transact sql

653


What language is oracle sql developer?

619