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

how to find the second highest salary from emp table?

Question Posted / manoj

211 Answers
373180 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 / manoj

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql data?

1034

What is difference between db2 and sql?

1046

How do you get column names only for a table (sql server)?

1217

What is a sql statement?

1019

how to enter numeric values as hex numbers? : Sql dba

1104

What are commit, rollback, and savepoint?

1049

what is self-join? : Sql dba

1244

What is sql comments?

1119

What is trigger in sql? Explain

1044

Which sql statement is used to delete data from a database?

1009

How do you explain an index?

1334

How can you tell the difference between an index and a view?

978

What are reports usually used for?

1085

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1097

what are set operators in sql? : Sql dba

1108