Write a query to find second highest salary of an employee.
Answer Posted / jeff
select max(salary)
from Emp
where rownum < 2;
| Is This Answer Correct ? | 3 Yes | 19 No |
Post New Answer View All Answers
how to drop an existing table in mysql? : Sql dba
what are date and time data types? : Sql dba
How to read xml file in oracle pl sql?
Which query operators in sql is used for pattern matching?
How to order siblings in oracle hierarchy queries?
How to fix oracle error ora-00942: table or view does not exist
How long will it take to learn pl sql?
What is the current version of sql?
In what condition is it good to disable a trigger?
State few characteristics of pl/sql?
What is native sql query?
What is user defined functions?
How do you declare a variable in pl sql?
Which nosql database is best?
Does pdo prevent sql injection?