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 use of friend function? : Sql dba

1055

when MSQL8.0 is in market

2137

What is an inner join sql?

1092

Why do we need unique key in a table?

1000

What is a boolean in sql?

1022

When is a declare statement required?

1191

What trigger means?

1031

How do I know if I have sql express or standard?

1062

What is the purpose of a sql?

1032

i have some prob lem to tell me about my self in interview first round ...

2213

how to do backup entire database? : Transact sql

1189

what does myisamchk do? : Sql dba

1075

What can I use instead of union in sql?

1018

How delete a row in sql?

1037

Can primary key be changed?

950