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 is set serveroutput on?

1087

Is oracle sql free?

927

explain what is mysql? : Sql dba

1031

Which tcp/ip port does sql server run?

956

How to disable a trigger name update_salary?

1195

What is the use of triggers?

979

What is rownum in sql?

965

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1064

what is the difference between cluster and non cluster index? : Sql dba

955

What is the unique index?

1003

Is sql port 1433 encrypted?

970

What are the benefits of pl sql?

1053

What is left inner join in sql?

985

What does an inner join do?

1090

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1142