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 a view? : Sql dba

1099

Is sql microsoft?

1058

What jobs use sql?

985

How do you write an inner join query?

956

Explain select statements in sql?

1059

what is text? : Sql dba

1075

How do I use google cloud in sql?

1093

Which sql most popular?

993

Explain isolation levels. : Transact sql

1074

Explain locks? : Transact sql

1010

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1109

Why do we use %rowtype & %type in plsql?

1053

explain the difference between delete , truncate and drop commands? : Sql dba

1096

What is a stored procedure in sql with example?

1136

what is unique key constraint? : Sql dba

1042