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 a database event trigger?

1210

How can I tell if sql is running?

1127

Explain select statements in sql?

1105

How can I speed up sql query?

1005

what is a unique key ? : Sql dba

1143

what is rdbms? : Sql dba

1058

What are different categories of sql commands?

1192

Which are the different character-manipulation functions in sql?

1109

How can you load microsoft excel data into oracle? : aql loader

1213

Explain constraints in sql?

1084

Why is there a need for sqlcode and sqlerrm variables?

1101

Why are aggregate functions called so?

1012

Explain how to use transactions efficiently : transact sql

1017

what are the advantages of using stored procedures? : Sql dba

1148

What does fetching a cursor do?

1132