Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361367 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 / abhijeet banarse
Select level,Max(sal) from emp1
Where level=&level connect by prior sal>sal
group by level;
Enter the level No=2 (Here enter 2 manually)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between null value, zero, and blank space?
Which constraints we can use while creating database in sql?
When can we use the where clause and the having clause?
who introduced sql?
What are the two characteristics of a primary key?
What is sqlite used for?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is pivot in sql?
What is sql injection vulnerability?
How can triggers be used for the table auditing?
What is the difference between instead of trigger and after trigger?
How do you update a value in sql?
What is the difference between python and sql?
List the different type of joins?
How to get unique records from a table?
