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

Can we shrink data file in sql server?

1027

What is SQL Azure Firewall?

136

What is indexed view?

966

You want to use a perspective in an mdx query. How do you select the perspective?

239

What are ddl triggers and types of ddl trigger?

1014

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1038

Can you explain what is the use of custom fields in report?

1041

Do you know how to make remote connection in database?

945

What is the stuff?

985

What is the difference between varchar and nvarchar datatypes?

1070

between cast and convert which function would you prefer and why?

941

What is enhanced database mirroring in sql server 2008?

954

Do you know what are the properties of the relational tables?

1013

What are various limitations of the views?

1044

What happens if date-only values are provided as date and time literals?

1004