Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368927 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 / nevin
select min(salary) from (select top 2 sal from table_name order by sal desc)salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
How to pipe multiline string to isql?
What is bind reference and how can it be created?
How do I remove duplicates in two columns?
What is cold data?
what is 'mysqlshow'? : Sql dba
Mention what does plv msg allows you to do?
Is subquery faster than join?
What is the process of debugging?
how to create a table index in mysql? : Sql dba
What is rename in sql?
Sql technical questions
what is cursor. write example of it. What are the attributes of cursor.
Why do we use sql constraints?
What view means?
How to execute a stored procedure?
