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 / jebitha

Answer Posted / jebitha

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

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Explain the structure of pl/sql in brief.

623

Do prepared statements prevent sql injection?

532

Can you have more than one key in a database?

511

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

507

Explain the advantages and disadvantages of stored procedure?

653

What is a table in a database?

584

Can we rollback after truncate?

569

How to run sql*plus commands in sql developer?

592

What is the difference between the sql*loader and import utilities? : aql loader

604

How to add a column ‘salary’ to a table employee_details?

595

What is oracle and pl sql?

665

Which join is like inner join?

566

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

556

What is a pragma statement?

724

what is the difference between a having clause and a where clause? : Sql dba

523