how to find the second highest salary from emp table?

Question Posted / shashank

211 Answers
368932 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

Answers were Sorted based on User's Feedback

how to find the second highest salary from emp table?..

Answer / jude

first find first maximum
then easy to find second maximum

Is This Answer Correct ?

98 Yes

330 No

Post New Answer

More SQL PLSQL Interview Questions

Why does sql need a server?

0 Answers

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers Polaris,

What is the difference between RDBMS and DBMS?

20 Answers Practical Viva Questions, Sapient, Stag Computers,

Does access use sql?

0 Answers

Can you have multiple SPs with the same name on a database?

2 Answers CGI, Quest,

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers Polaris,

What is not equal in sql?

0 Answers

Whate is use of MOD function in pl/sql.

3 Answers Oracle,

what is denormalization. : Sql dba

0 Answers

Is sql difficult?

0 Answers

Is null operator in sql?

0 Answers

For more SQL PLSQL Interview Questions Click Here