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 many types of privileges are available in sql?

1350

Inline the values in PL/SQL, what does it mean.?

1232

Why use triggers in sql?

961

What is a nested table in word?

961

How can check sql version from command line?

1089

What is normalization sql?

1063

Why do we create stored procedures & functions in pl/sql and how are they different?

950

What are the built in functions of sql?

1030

What is Histogram?

1564

What are different types of functions in sql?

1006

What does seeding a database mean?

972

What is data profiling in sql?

1084

What is Difference Between Unique and Primary Key Constraints?

1108

How do you optimize a stored procedure query?

1000

What is trigger with example?

1104