select emp_name,max(salary) from Employee.

From an Employee table, how will you display the record
which has a maximum salary?

Question Posted / sharmila

Answer Posted / sharmila

select emp_name,max(salary)
from Employee.

Is This Answer Correct ?

55 Yes

44 No

Please Help Members By Posting Answers For Below Questions

What is the difference between microsoft access and sql server?

1057

What is pls_integer in pl sql?

1105

Is pl sql still used?

975

What is the purpose of the primary key?

1063

explain the delete statements in sql

1054

What is the difference between cluster and non-cluster index?

1106

How do I audit the sql sent to the server?

1010

what is a composite primary key ? : Sql dba

1050

What is a unique key?

1054

What are the benefits of pl sql?

1121

What is the use of partition by in sql?

994

What is varchar data type in sql?

1082

What is multiple partition?

967

Is there a 64 bit version of ssms?

961

What is file based approach?

941