Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118642 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 does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What are sql built in functions?
Can we use threading in pl/sql?
When is the update_statistics command used?
Enlist some predefined exceptions?
What is difference between db2 and sql?
What is native sql query?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is the purpose of the sql select top clause?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is the starting oracle error number?
What are procedures used for?
What is the most restrictive isolation level? : Transact sql
How do you write an index?
What is procedure and function in sql?
