select ename,sal from employees where rownum <=1 order by sal desc

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

Question Posted / kavitha

Answer Posted / kavitha

select ename,sal
from employees
where rownum <=1
order by sal desc

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to run sql functions in pl/sql?

992

What is the difference between function, procedure and package in pl/sql?

1138

What is dml and ddl?

902

what is a foreign key ? : Sql dba

1028

What is execution plan in sql?

981

what is a constraint? Tell me about its various levels. : Sql dba

932

Does execute immediate commit?

1153

Explain how to use transactions efficiently : transact sql

926

What are the string functions in sql?

926

What are hotfixes and patches?

890

what is the command used to fetch first 5 characters of the string? : Sql dba

1587

Does user triggers have entry for trigger with compilation errors?

975

Can we write ddl statements in functions?

1054

Which is faster joins or subqueries?

931

Does sql support programming?

1008