Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361358 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 / debasish
select ename,sal from (select ename,sal,row_number()
over(order by sal desc)rn from emp)
where rn=1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I view stored procedures?
How does an execution block start and end in pl sql?
Define commit?
What are all the different types of indexes?
What is data profiling in sql?
What is use of term?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Is sql a oracle?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is a composite primary key?
What is autocommit sql?
What are pl/sql packages?
How can a function retun more than one value in oracle with proper example?
How many types of relationship are there?
What operators deal with null?
