Write a query to find second highest salary of an employee.
- 27 Answers
- 22021 Views
- I also Faced
- E-Mail Answers
Answer Posted / kitcat
SELECT salary
FROM (SELECT salary FROM emp
ORDER BY DESC salary)
WHERE RowNum=2
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
How do you optimize a stored procedure query?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is ttitle and btitle?
Can variables be used in sql statements?
Why we use cross join?
what are integrity rules?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Can we insert in sql function?
How do you delete a table?
what does the t-sql command ident_current does? : Transact sql
What is java sql driver?
What do you mean by field in sql?
Can a table have no primary key?
What are different types of triggers?
