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 ?

4 Yes

11 No

Please Help Members By Posting Answers For Below Questions

how do you control the max size of a heap table? : Sql dba

1026

Explain mutating table error.

1263

What are the different ddl commands in sql?

1251

How do I run a sql trace?

1003

What are the commands used in sql?

1135

What are the different sql languages?

1093

What are the two parts of design view?

1067

what is denormalization. : Sql dba

1162

How to convert comma separated string to array in pl/sql?

1242

What is sql deadlock?

1219

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1250

Can we rollback delete command?

1038

What is rank () in sql?

999

What does select count (*) mean in sql?

1075

what is rdbms? : Sql dba

1066