SELECT LAST_NAME,MAX(SALARY) FROM EMPLOYEES GROUP

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

Question Posted / jayshree

Answer Posted / jayshree

SELECT LAST_NAME,MAX(SALARY)
FROM EMPLOYEES
GROUP_BY SALARY;

Is This Answer Correct ?

2 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is dialect in sql?

954

What are basic techniques of indexing?

1388

How many times can we commit in a loop?

1026

How do you declare a constant?

965

What is compilation error in pl sql?

985

What is form and report?

995

What problem one might face while writing log information to a data-base table in pl/sql?

1171

what is the difference between $message and $$message? : Sql dba

1003

What is an exception in pl/sql?

1094

What is the difference between between and in condition operators?

1010

What is the difference between distinct and unique in sql?

956

What are pl/sql cursor exceptions?

1111

Why do we use procedures in pl sql?

1046

What are the two types of cursors in pl sql?

1085

What is trigger and types?

1030