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 are statistics?

953

Write a SQL query to delete a table?

1080

What is difference between oltp and olap?

984

What is the stuff?

950

Show Practically Sql Server Views are updatable?

1056

What do I need to start working with sql studio? : sql server management studio

1053

What is difference between views and stored procedures?

930

What is the difference between clustered and a non-clustered index?

979

Explain intellisense for query editing

980

What is SQL Azure?

105

What is transaction server auto commit?

990

Explain security with sql azure?

186

What are system databases in ms sql server?

968

What is ms sql server index?

1026

What is ms sql server service broker?

935