find the second highest salary of the emp table

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you assign multiple query result rows to a variable?

552


What is the usage of merge statement?

676


How to write a query with a left outer join in oracle?

607


Explain constraining triggers.

599


Define oracle database

596






Explain the use of consistent option in exp command.

554


What are the differences between char and varchar2 in oracle?

565


What is the maximum number of triggers that can be applied to a single table?

561


How a tablespace is related to data files?

583


What is oracle server autotrace in oracle?

616


What is Reduced List of Values?

1708


How to change user password in oracle?

608


What are the common oracle dba tasks?

625


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1470


How to create a new table in your schema?

608