select top 1 emp_name,emp_sal from employee order by emp

Find top Nth employee from each department in terms of
salary?

Question Posted / khushboo

Answer Posted / khushboo

select top 1 emp_name,emp_sal from employee order by emp_sal
desc

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Tell me what is a linked server?

651

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

678

How do you rename a table in sql server?

568

How to set the current database in ms sql server?

601

Can a database be shrunk to 0 bytes, if not, why?

719

What is the use of tempdb? What values does it hold?

647

Find first and last day of current month in sql server

683

How to find tables without indexes?

701

Explain how would you store your query in an SSRS report or a Database server?

What are points to remember while using the fillfactor argument?

638

What do you mean by normalisation?

593

What is the contrast between sql and mysql?

697

What is raid and what are different types of raid levels?

687

Is it possible to create trigger on views?

628

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

698