SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT MAX(SALARY)

how to find the second highest salary from emp table?

Question Posted / chiguru&

211 Answers
373017 Views
CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
E-Mail Answers

Answer Posted / chiguru&

SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we create a trigger on view?

944

Can I call a procedure inside a function?

1074

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2135

How do I start sql from command line?

1081

What is difference between hql and native sql?

1236

Why trigger is used in sql?

1015

Why do we use triggers?

1014

what is schema? : Sql dba

1111

How to run sql commands in sql*plus?

1251

Which join is like an inner join?

1091

What is the difference between microsoft access and sql server?

1104

What is embedded sql in db2?

1061

What is Collation Sensitivity ? What are the various type ?

1001

What is the use of stored procedures?

1105

How to start the command-line sql*plus?

1109