Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / mallikarjuna
select max(sal) from emp where sal<(select max(sal) from emp);
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are two statement types in sql?
How to run sql statements through the web interface?
Should I use mbr or gpt?
What is %s in sql?
How do you get column names only for a table (sql server)?
What is nosql example?
what is 'mysqld'? : Sql dba
Is sql open source?
what is bdb (berkeleydb)? : Sql dba
List and explain the different types of join clauses supported in ansi-standard sql?
Are subqueries faster than joins?
What is nvarchar max in sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is the difference between the implicit and explicit cursors?
what is the difference difference between procedure and packages