Write a query to find second highest salary of an employee.
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
What is difference between rank () row_number () and dense_rank () in sql?
Can a composite key be null?
Do prepared statements prevent sql injection?
What are pl sql data types?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is sqlerrm?
Is sql port 1433 encrypted?
What is the starting oracle error number? What is meant by forward declaration in functions?
Can a table contain multiple foreign key’s?
What is the difference between pl and sql?
What is mdf ldf and ndf?
Explain the update statement in sql
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is scope of pl sql developer in future?
Why do we use cursors?