Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118302 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / nitika
SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the difference between distinct and unique in sql?
What are tables in sql?
Why do we use sql constraints?
How many types of primary keys are there?
What are the advantages of sql?
What are the disadvantages of file system?
How many aggregate functions are available there in sql?
Can we use commit inside a trigger?
Will truncate release space?
how to use case expression? : Sql dba
Which join condition can be specified using on clause?
Mention what pl/sql package consists of?
How does sql store data?
What is synonyms?
What is view explain with example?
