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 / prathapshankarshiva
select max(salary) from (select salary from table1 where
salary<(select max(salary) from table1))
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is database mirroring?
How to declare and use cursor variables?
What is measure group, measure? : sql server analysis services, ssas
Explain the difference between delete,drop and truncate in SQL Server?
What is database isolation in sql server? : sql server database administration
Explain transaction server consistency?
Explain the properties of the relational tables?
What are different backups available in sql server?
Find columns used in stored procedure?
Is it possible in sql table to have more than one foreign key?
How to delete multiple rows with one delete statement in ms sql server?
What do you mean by sql server agent?
Is it important for a database administrator to understand the operating system and file access?
What are different types of statement?
What is nonclustered index on computed columns?