Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / naresh kumar kalangi
select top 1 * from (select top 2 * from emp order by sal
desc)s order by sal
| Is This Answer Correct ? | 5 Yes | 8 No |
Post New Answer View All Answers
Define concurrency control. : Transact sql
How do I turn a list into a table?
What is optimistic concurrency control? : Transact sql
What is cursor explain with example?
What information is needed to connect sql*plus an oracle server?
What is scope of pl sql developer in future?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Can I create table without primary key?
Where the sql database files are stored?
Is time a data type in sql?
what is timestamp in mysql? : Sql dba
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What are the types of records?
How many aggregate functions are available there in sql?
how many groups of data types? : Sql dba