SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL) FROM EMPLOYEE

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / kotravel. b

69 Answers
118817 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answer Posted / kotravel. b

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

THIS will surly give 2^nd max sal ok this correct ans ok....

Is This Answer Correct ?

85 Yes

13 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4299

what are date and time data types? : Sql dba

994

What are the sql aggregate functions?

1143

What is indexes?

1064

what is union? : Sql dba

1036

What is AUTH_ID and AUTH_USER in pl/sql ?

2199

Is sql a oracle?

986

What is pragma in sql?

1090

how can we know the number of days between two given dates using mysql? : Sql dba

1053

How run sql*plus commands that are stored in a local file?

1071

What are the different sql languages?

1047

What does count (*) do in sql?

1020

What is multiple partition?

974

What does desc stand for?

1079

what is the difference between a having clause and a where clause? : Sql dba

1099