Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120164 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
how to shutdown mysql server? : Sql dba
What is a full join sql?
how to run 'mysql' commands from a batch file? : Sql dba
What do you mean by table in sql?
What does select top 1 do in sql?
what is data control language? : Sql dba
What is the difference between having clause and where clause?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How do I remove duplicates in two columns?
How many sql statements are used?
How to write a query to show the details of a student from students table whose
Does truncate free space?
What is use of term?
Is drop table faster than truncate?
how is exception handling handled in mysql? : Sql dba
