select top(1) sal From sample where sal in (select top(2) salfrom sample

1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.

Question Posted / swapna

Answer Posted / swapna

select top(1) sal From sample
where sal
in (select top(2) salfrom sample order by saldesc)
order by sal asc

Is This Answer Correct ?

0 Yes

7 No

Please Help Members By Posting Answers For Below Questions

6. Display the client name and order date for all orders using the traditional method.

2308

please explain.. DB architecture ...

2023

How can windows applications connect to oracle servers?

1057

what is the difference between substr and instr function in oracle?

1090

How can we force the database to use the user specified rollback segment?

1148

State and explain the different types of data models?

944

What is an oracle database table?

1015

Can we connect to ORACLE db using Windows Authentication?

1257

How to upsert (update or insert into a table)?

1000

How to create a new user account in oracle?

1021

How to increment dates by 1 in oracle?

1089

Is there a combination of "like" and "in" in sql?

1065

What are the built-in functions used for sending Parameters to forms ?

3388

IS it possible to built the oracle database without setting the kernal parameters?

2348

How to recover a dropped table in oracle?

1048