Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / google
Select min(sal) from emp where sal in (
select top 3 sal from emp
order by sal desc )
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is rownum in sql?
What is trigger explain it?
What does plv msg allows you to do?
Is truncate ddl or dml?
What are two statement types in sql?
how do you control the max size of a heap table? : Sql dba
How do you optimize a stored procedure query?
What is mutating sql table?
What is composite primary key in sql?
What is sql comments?
Which tcp/ip port does sql server run?
How do you optimize a query?
define sql update statement ? : Sql dba
how to enter characters as hex numbers? : Sql dba
How to run sql functions in pl/sql?