Write a query to find second highest salary of an employee.
Answer Posted / shahid parvez
select max(sal) from Emp where sal < (select max(sal) from
Emp)
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What do you know by pl/sql cursors?
What is compilation error in pl sql?
Can a key be both primary and foreign?
Show the cursor attributes of pl/sql.
how would you get the current date in mysql? : Sql dba
Does mysql_real_escape_string prevent sql injection?
Explain the methods used to protect source code of pl/sql.
What are inner outer left and right joins in sql?
How to add new employee details in an employee_details table with the following details
What is crud diagram?
How to use sql*plus built-in timers?
Write a sql query to find the names of employees that begin with ‘a’?
What is sql table?
what are sequences
what is the functionality of the function htmlentities? : Sql dba