SELECT max(salary) FROM Employee WHERE salary NOT IN (SELECT max(salary) FR

Write a query to get all details of employee who has maximum
salary from employee table

Question Posted / krishh

Answer Posted / krishh

SELECT max(salary) FROM Employee WHERE salary NOT IN (SELECT max(salary) FROM Employee);

Is This Answer Correct ?

23 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is surrogate key? : sql server analysis services, ssas

1160

How to add an address record into adventureworkslt?

1028

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1098

How to find related tables in sql server?

1001

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1059

How to find the version of sql server? : sql server database administration

1164

What is Federation and Federation Member?

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1060

What are sub reports?

208

How can we rewrite sub-queries into simple select statements or with joins?

1027

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1039

what are defaults? : Sql server database administration

1162

How to convert numeric expression data types using the cast() function?

1120

Define compound operators?

964

How to move database physical files in ms sql server?

1097