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

Does sql require a server?

1019

How does cross join work in sql?

1022

How do I run a pl sql program?

1133

how to show all tables with 'mysql'? : Sql dba

1121

How many functions are there in sql?

1043

Are stored procedures compiled?

932

What is difference between ms sql and mysql?

972

What is a Mapplet?

1129

What are the advantages of pl sql over sql?

1028

Describe types of sql statements?

1064

How to get help at the sql prompt?

1122

Mention what pl/sql package consists of?

1006

How is a process of pl/sql compiled?

1167

Are left and right joins the same?

1092

Explain isolation levels. : Transact sql

1074