this is for 2nd highest sal in sql server database select * from emp whe

find out the second highest salary?

Question Posted / ananth

55 Answers
87741 Views
Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
E-Mail Answers

Answer Posted / ananth

this is for 2nd highest sal in sql server database

select * from emp where sal=(select max(sal) from emp where
sal<(select max(sal) from emp))

Is This Answer Correct ?

119 Yes

13 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

1114

How to convert times to characters in oracle?

979

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1814

How to create a new user account in oracle?

955

How to Truncate Table in Oracle

1094

What is a user role in oracle?

1067

Why do you create or replace procedures rather that drop and recreate.

948

Explain drop constraint oracle?

992

Why oracle is used?

998

Is insert autocommit in oracle?

1019

definition of cluster and non-clustered index?

2962

Explain the use of online redo log files in oracle.

993

Why do we use coalesce function in oracle?

1053

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1326

what are archived logs?

2144