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

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

1275

What is mutating error?

1007

What are the packages in pl sql?

1067

What schema means?

939

What is a string data type in sql?

1102

What are different types of triggers?

1186

What is the difference between pl and sql?

1153

What does trigger mean in slang?

1126

Is left join faster than join?

1096

What is bulk compiling in pl/sql.?

1192

What are different sql data types?

1129

Define select, insert, create, delete, update, drop keywords

1094

What are the types of records?

1038

Is sql workbench free?

1047

Can we rollback truncate?

1052