SELECT TOP (3)with ties empsalry FROM empsalr order by emp

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE

Question Posted / kumari

Answer Posted / kumari

SELECT TOP (3)with ties empsalry
FROM empsalr

order by empsalry desc;

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Does an index slow down updates on indexed columns?

939

What is equi join with example?

1059

What are the different types of subquery?

1114

How can you hide the sql server instances?

990

What are the recovery models in sql server 2000?

943

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

894

How do we Backup SQL Azure Data?

108

How many categories of functions based their return modes?

1076

When to use null data driven subscription?

202

what is raid and what are different types of raid configurations? : Sql server database administration

1000

Explain the relational database management system (rdbms)?

1052

Which is better statement or preparedstatement?

885

What is a mutating table error and how can you get around it?

1007

How to get a list all databases on the sql server?

1047

What is the minimum recommended amount of ram for sql server 2012 enterprise?

906