How can get second highest salary in sql?



How can get second highest salary in sql?..

Answer / Dilshad Ali

To find the second highest salary, you can use a subquery. Example: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Can you upgrade sql express to full sql?

1 Answers  


How do you run a query?

1 Answers  


i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,


how can we repair a mysql table? : Sql dba

1 Answers  


What is input buffer in sql*plus?

1 Answers  


Is sql between inclusive?

1 Answers  


i have some prob lem to tell me about my self in interview first round ...

1 Answers  


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1 Answers  


explain commit and rollback in mysql : sql dba

1 Answers  


What is cartesian join in sql?

1 Answers  


How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1 Answers  


What does the sign mean in sql?

1 Answers  


Categories