Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 103195 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
In pl/sql, what is bulk binding, and when/how would it help performance?
What is the difference between rename and alias?
What are variables in pl sql?
What are the types of records?
Can we join tables without foreign key?
What is clustered index in sql?
What is sql injection vulnerability?
What is character functions?
What is dcl in sql?
What are the indexing methods?
What is a clob in sql?
What are different types of sql?
what does the t-sql command ident_incr does? : Transact sql
What is the syntax to add a record to a table?
what is view? : Sql dba
