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
How do I save the results of sql query in a file?
What is PL/SQL Records?
Why are indexes and views important to an organization?
What are the benefits of stored procedures?
Why we use triggers in mysql?
What is package in pl sql with an examples?
What is rownum and rowid?
Is sql easier than java?
What are the types pl/sql code blocks?
What is data definition language?
Does varchar need length?
How is sql used in oracle?
What is difference between table and view?
How do you determine the current isolation level? : Transact sql
What language is oracle sql developer?