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 are the different types of functions in sql?
What are the disadvantages of file system?
What are the types of subqueries?
What is the difference between mdf and ndf files?
what does the t-sql command ident_current does? : Transact sql
describe transaction-safe table types in mysql : sql dba
how can we optimize or increase the speed of a mysql select query? : Sql dba
Define SQL and state the differences between SQL and other conventional programming Languages?
How can use stored procedures in sql?
What is cte?
What is package in pl sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is varchar data type in sql?
How do I find duplicates in sql?
What does where 1 1 mean in sql?