SELECT * FROM employees WHERE salary = ( SELECT MIN ( r.salary)

how to find the second highest salary from emp table?

Question Posted / nitin umale

211 Answers
367438 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 / nitin umale

SELECT *
FROM employees
WHERE salary =
( SELECT MIN ( r.salary)
FROM ( SELECT salary
FROM ( SELECT DISTINCT salary
FROM employees
ORDER BY NVL(salary,0) DESC
)
WHERE rownum<3) r
);

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are instead of triggers?

1039

What is a sql profiler?

1017

How to take user input in pl sql?

1161

Why trigger is used in sql?

964

Explain the purpose of %type and %rowtype data types with the example?

984

Is crud a cuss word?

1032

how to concatenate two character strings? : Sql dba

1093

what is timestamp in mysql? : Sql dba

1069

What are analytic functions in sql?

1021

How to run sql*plus commands in sql developer?

1147

What is sql resultset?

979

What is percent sign in sql?

1281

What does fetching a cursor do?

1081

What is compiled query?

1030

What is varray in pl sql?

1067