Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 103210 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / baburav zore
select max(sal) from employee where sal<(select sal from employee);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why do we need unique key in a table?
What is pl sql in oracle?
What is cold data?
Which command is used to delete a trigger?
What is the difference between execution of triggers and stored procedures?
What is a database trigger?
What does sql stand for?
How is data stored in sql?
What company owns postgresql?
How does rowid help in running a query faster?
What is sql indexing?
How do I view output in sql developer?
What is a variable in sql?
What is trigger with example?
What is an exception in PL/SQL? What are the two types of exceptions?
