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
How can we debug in PL/SQL?
How can I change database name in sql?
How to start the command-line sql*plus?
What is the command used to fetch the first 5 characters of a string?
What is consistency?
Where can I learn sql for free?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what are the differences among rownum, rank and dense_rank? : Sql dba
Is sql better than access?
What is sql rowcount?
What are the possible values for the boolean data field?
What is localdb mssqllocaldb?
What is the sql case statement?
What is pl sql collection?
What is sap sql anywhere?