select ename,sal from emp where sal = (select max(sal) from emp) and ro

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

Question Posted / santosh

Answer Posted / santosh

select ename,sal
from emp
where sal = (select max(sal) from emp)
and rownum<= 1

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Differentiate pl/sql and sql?

1052

What is clustered index in sql?

1040

what are the advantages of using stored procedures? : Sql dba

1091

what is query cache in mysql? : Sql dba

1015

What is right join in sql?

1075

Which are the different character-manipulation functions in sql?

1039

Can we perform dml on view?

1029

What is multiple partition?

952

How to run sql commands in sql*plus?

1157

How do I pipe the output of one isql to another?

990

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1094

how to use in conditions? : Sql dba

992

what are date and time functions in mysql? : Sql dba

963

What is hibernate and its relation to sql?

1100

What does the acronym acid stand for in database management?

1021