how to find the second highest salary from emp table?
- 211 Answers
- 322077 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 / gaurav singh 'viccky'
select salary from user=(select max(salary)from user where
salary < (select max(salary)from user))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can variables be used in sql statements?
What do you mean by dbms? What are its different types?
Explain the savepoint statement.
How to avoid using cursors?
How will you distinguish a global variable with a local variable in pl/sql?
Is left join same as join?
List the ways to get the count of records in a table?
Is pl sql different from sql?
Which is better join or inner query?
explain the difference between delete , truncate and drop commands? : Sql dba
When you have to use a default "rollback to" savepoint of plvlog?
How are sql commands classified?
Can delete statement be rollbacked?
What are the main features of cursor?
What is materialized view in sql?
