Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / rajesh.m
Crete Table Curtest(Emp char(40),salary money)
------------------------------------------------
Select Min(Salary) from Curtest where Salary
in (select Top 2 Salary from Curtest)
--------------------------------------------------
| Is This Answer Correct ? | 21 Yes | 33 No |
Post New Answer View All Answers
Is a foreign key always unique?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Mention what plvcmt and plvrb does in pl/sql?
Is sql database free?
What are some emotional triggers?
What is sqlerrd?
how do you know if your mysql server is alive? : Sql dba
What is a table?
What types of commands can be executed in sql*plus?
What is a .db file?
what is try_catch block in procedure
Is inner join faster than left join?
how many tables will create when we create table, what are they? : Sql dba
What is identity column in sql server?
What are sql constraints?