Select * from EMP_TAB where salary = (select max(salary) from EMP

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

Question Posted / vineet

Answer Posted / vineet

Select * from EMP_TAB where salary = (select max(salary) from EMP_TAB;

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is nolock hint in sql server 2008

1065

What is the impact on other user sessions when creating indexes?

872

What is raid, and how it can influence database performance?

1003

What is unpivot?

965

What does it mean to be in union?

870

What is the process of indexing?

941

What do you do in data exploration

926

Can we do dml on views?

911

Why I can not enter 0.001 second in date and time literals in ms sql server?

1010

How to fetch the next row from a cursor with a "fetch" statement?

1015

What is sleeping status in sql server?

980

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

922

What is indexing a document?

967

Which are ddl commands?

969

How to handle error or exception in sql?

932