Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / m
select max(sal) from emp where sal<(select max(sal) from
emp))
| Is This Answer Correct ? | 222 Yes | 39 No |
Post New Answer View All Answers
What is sqlcontext?
What does rownum mean in sql?
What is the sql*loader? : aql loader
How do you update sql?
Can we enter data in a table in design view?
What is raid? How does it help storage of databases?
How do I sort a table in sql?
define sql delete statement ? : Sql dba
What is scalar function in sql?
Explain autonomous transaction.
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Which sql statement is used to return only different values?
What is a procedure in pl sql?
what is sql server agent? : Sql dba
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba