how to find nth highest salary

Answer Posted / rajendra prasad reddy penumall

select salary=max(salart)from from EmpMaster

Is This Answer Correct ?    17 Yes 182 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is default constraint in ms sql server?

538


What is a heap?

615


How do I schedule a sql server profiler trace?

538


How do you handle datasets larger than 50 gb?

140


What is the sql case statement used for?

559






What are different backups available in sql server?

606


How to create user defined functions with parameters?

644


what exactly sql injuction.how to overcome.....

2041


Do you know what is openxml in sql server?

613


do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

483


What does it mean if @@cursor_row returns a negative number?

575


You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

485


Which is the latest version of sql server and when it is released?

545


What do you mean by authentication modes in sql server?

611


Explain the concepts and capabilities of sql server?

544