Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367540 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 / mohamed hussain
select salary from
(select salary,Dense_RANK() over (Order by salary desc) as
Level from salary) TMP
where Level=@Level
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you rename a table in sql?
What is trigger and how to use it in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Does inner join return duplicate rows?
what are integrity rules?
How do you declare a constant?
Explian rowid, rownum? What are the psoducolumns we have?
What will you get by the cursor attribute sql%notfound?
In pl/sql, what is bulk binding, and when/how would it help performance?
How would you reference column values before and after you have inserted and deleted triggers?
What are operators available in sql?
What are sql*plus environment variables?
What is an escape character in sql?
Explain the purpose of %type and %rowtype data types?
What is meant by user defined function?
