select max(sal) from emp where sal<(select max(sal) from emp);

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / venkat

Answer Posted / venkat

select max(sal) from emp where sal<(select max(sal) from
emp);

Is This Answer Correct ?

19 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is 19 null in sql?

532

what is the use of friend function? : Sql dba

541

Why is the cursor important?

539

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

545

What are all different types of collation sensitivity?

523

How do I count duplicates in sql?

545

What is pl sql collection?

523

How can we avoid duplicating records in a query?

562

What is file based approach?

487

What is triggering circuit?

592

What is the best free sql database?

564

What are dml commands?

525

What is structural independence and why is it important?

546

Can we use ddl commands in pl sql?

554

What is error ora-01000: maximum open cursors exceeded

600