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


Please Help Members By Posting Answers For Below Questions

What is database mirroring?

546


How to declare and use cursor variables?

568


What is measure group, measure? : sql server analysis services, ssas

524


Explain the difference between delete,drop and truncate in SQL Server?

574


What is database isolation in sql server? : sql server database administration

543






Explain transaction server consistency?

500


Explain the properties of the relational tables?

530


What are different backups available in sql server?

579


Find columns used in stored procedure?

511


Is it possible in sql table to have more than one foreign key?

588


How to delete multiple rows with one delete statement in ms sql server?

493


What do you mean by sql server agent?

518


Is it important for a database administrator to understand the operating system and file access?

487


What are different types of statement?

497


What is nonclustered index on computed columns?

552