How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
Answer Posted / neon
select salary from emp
where salary = (select max(salary) from emp
where salary <>(select max(salary) from emp)
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Is it possible to update the views? If yes, how, if not, why?
What is the difference between functions and scalar functions?
What is bcp? When does it used?
how you can configure a running aggregate in SSRS?
Explain a join?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Explain primary key?
Can two different columns be merged into single column? Show practically?
How we can refresh the view?
Explain four layers of abstraction microsoft architectured?
How can change procedure in sql server?
What are character string data types in ms sql server?
what are the critical issues you have resloved in your company
How to convert a unicode strings to non-unicode strings?
What happens if null values are involved in bitwise operations?