Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / prem chhappesh
select max(salary) from emoplyee where salary not in(select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the primary key?
What is a behavioral trigger?
What is delimiter sql?
what are the security recommendations while using mysql? : Sql dba
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Why do we use subquery?
What is the difference between alter trigger and drop trigger statements?
Explain mutating table error.
What is offset in sql query?
What is row_number () in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is substitution variable in pl sql?
List and explain the different types of join clauses supported in ansi-standard sql?
Does sap use sql?
What is the best sql course?