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

Will truncate release space?

956

What is recursive stored procedure?

1102

what is text? : Sql dba

1075

Can we rollback truncate?

1002

Can we create a trigger on view?

901

what is the functionality of the function htmlentities? : Sql dba

970

how do you know if your mysql server is alive? : Sql dba

1079

What is sql lookup?

925

How do you declare a constant?

963

What is crud sql?

990

What is substitution variable?

1056

What is rank () in sql?

945

What is trigger in pl sql?

1004

Differentiate between sga and pga.

1167

List and explain the different types of join clauses supported in ansi-standard sql?

1357