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

where can you add custom error messages to sql server? : Sql server administration

1133

What are commit and rollback in sql?

1140

What is the use of sql profiler in sql server 2012?

912

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2792

How to recover from sql injection? : sql server security

1030

Mention the differences between having and where clause.

1072

How do you delete duplicate records in sql server?

1076

Scalability, Availability, Integration with internet, etc.)?

2888

How to enable tcp/ip protocol on a sql server?

1180

Explain use of expression builder.

1033

Can a unique index be created on a column, which contains null?

928

How to use “drop” keyword in sql server and give an example?

1140

How many types of triggers are there?

1078

Is there any difference between primary key and unique with the not null condition?

962

Explain what are sparse columns?

1005