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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an indice?

582


Can group functions be mixed with non-group selection fields in ms sql server?

553


Define clusters?

656


What are data resources?

514


What are logical database components? : SQL Server Architecture

491






How to set a database state to offline in ms sql server?

545


What is filestream?

564


Your table has a large character field there are queries that use this field in their search clause what should you do?

512


What is difference between delete & truncate commands?

560


How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

765


Which joins are sql server default?

524


How to send email from database?

599


What is normalization of database? What are its benefits?

525


How to stop log file growing too big?

585


Explain different backup plans?

538