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

Does sql view stored data?

900

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1041

Why do we need cursors in pl sql?

1005

What is clustered index in sql?

1003

What are the benefits of pl sql?

1054

What is clause?

1067

How to look at the current sql*plus system settings?

1082

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1219

Does truncate table reset auto increment?

941

How do I kill a query in postgresql?

1014

Does sqlite need a server?

995

What is the main difference between sql and pl/sql?

1028

What are the topics in pl sql?

932

What is inner join in sql?

1004

Can you do multiple joins in sql?

977