Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120165 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);
I don't think this will work correct me if i am
wrong.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 write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Explain correlated query work?
how is myisam table stored? : Sql dba
How to start the command-line sql*plus?
Do ddl statements need commit?
What are records give examples?
What is an ndf file?
Does asenumerable execute the query?
Explain cursor types?
What does where 1 1 mean in sql?
How can you view the errors encountered in a trigger?
What is string data type in sql?
What is a recursive join sql?
How to add new employee details in an employee_details table with the following details
Are dml statements autocommit?
