select ename , max(sal) from emp group by ename;

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

Question Posted / ahmad nazmi

Answer Posted / ahmad nazmi

select ename , max(sal)
from emp
group by ename;

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the difference between a subquery and a join?

1106

How many indexes can be created on a table in sql?

1053

What is online transaction processing (oltp)?

1017

What is form and report?

985

How many types of relationship are there?

1031

How to revise and re-run the last sql command?

1163

Can we create foreign key without primary key?

985

What is difference sql and mysql?

986

how to calculate expressions with sql statements? : Sql dba

1032

What are different types of functions in sql?

1004

Can I join the same table twice?

1043

What trigger means?

977

how to convert character strings to numeric values? : Sql dba

1106

What is a left inner join?

1013

What is a sql select statement?

1039