select max(sal) from emp where sal<(select max(sal) from emp);

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

Question Posted / malli

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

Answer Posted / malli

select max(sal) from emp where sal<(select max(sal) from emp);

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is synonyms?

1051

what are numeric data types? : Sql dba

1058

How many types of cursors are available in pl/sql?

1101

What are the various restrictions imposed on view in terms of dml?

963

Is not equal in sql?

1010

What are the steps for performance tuning.

1327

Can 2 queries be executed simultaneously in a distributed database system?

1140

What is memory optimized table?

1037

what are the 'mysql' command line arguments? : Sql dba

1133

What is the difference between nvl function, ifnull function, and isnull function?

1101

what are local and global variables and their differences? : Sql dba

1069

What is record data type?

908

What is the difference between sum and count in sql?

984

discuss about myisam key cache. : Sql dba

1019

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2552