ANS: select max(salary) from Employees where salary not in (select max(s

find the second highest salary of the emp table

Question Posted / guest

Answer Posted / guest

ANS:
select max(salary) from Employees
where salary not in
(select max(salary) from Employees )

Is This Answer Correct ?

9 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how to do daily transactions with out sql* loader control file regesterd in apps?

1733

what is port in oracle? how is it related to database application.

1992

How to view the tablespaces in the current database?

1027

What are the advantages of oracle 12c?

1237

What is a tns service name?

1058

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2065

How do we create privileges in oracle?

1103

What privilege is needed for a user to query tables in another schema?

1034

What does sharding mean?

1056

How much memory your 10g xe server is using?

1153

what is dynamic SGA and static SGA

4492

What to do if dba lost the system password?

1248

What are the different oracle database objects?

1150

How to invoke the original export import utilities?

1135

Can group functions be used in the order by clause in oracle?

1048