Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367456 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
Can a composite key be null?
What are sql triggers used for?
Why functions are used in sql?
What is primary key and foreign key?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is primary key in db?
What is a temporal data type?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
how do you tune the slow running queries in oracle db , explain the methodology
What is pragma in pl sql?
Can you have more than one trigger on a table?
How many rows can sqlite handle?
how to select unique records from a table? : Sql dba
What is a sql profiler?
what is a record in a database ? : Sql dba
