Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118059 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / sandip
SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
The correct one is.......
SELECT MAX(SAL) as SAL FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is rtm stands for?
What is sql profiling in oracle?
define data blocks ? : Sql dba
How do I run a pl sql program?
What operators deal with null?
What is PL/SQL Records?
What are few of the schema objects that are created using PL/SQL?
How are sql commands classified?
is mysql query is case sensitive? : Sql dba
What does an inner join do?
What is the difference between a primary key and a unique key?
How is a PL/SQL code compiled?
What is %type in sql?
Which join is like inner join?
How do I remove duplicates in two columns?
