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 does := mean in pl sql?

557

what is commit? : Sql dba

619

what is index? : Sql dba

558

What is left join in postgresql?

544

How many types of normalization are there?

493

What is pl sql code?

593

How to handle bulk data?

893

What are pl sql data types?

552

What are the benefits of pl sql?

530

What is varchar used for?

538

What kind of join is join?

559

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

623

What is primary key sql?

546

What is the primary use of normalization?

531

What are the events on which a database trigger can be based?

598