select *from employees where rownum<2 order by salary desc; or select

From an Employee table, how will you display the record
which has a maximum salary?

Question Posted / mrityunjay singh

Answer Posted / mrityunjay singh

select *from employees where rownum<2 order by salary desc;
or
select * from employee where sal=(select max(sal) from
employee);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the possible values that can be stored in a boolean data field?

1001

What is sqlerrd?

968

What is dcl in sql?

962

Are stored procedures faster than dynamic sql?

1041

What is sql and explain its components?

1068

What is informix sql?

980

What is embedded sql with example?

1056

What does joining a thread mean?

1021

What is optimistic concurrency control? : Transact sql

985

Explain what is dbms?

1067

how to get @@error and @@rowcount at the same time? : Sql dba

1028

What is a schema? How is it useful in sql servers?

1122

Mention what are different methods to trace the pl/sql code?

1208

What are the two types of cursors in pl sql?

1082

How do I find duplicates in two columns?

1169