select * from(select e.* from emp e order by sal desc) where rownum=1;

Write a query to get all details of employee who has maximum
salary from employee table

Question Posted / sureshramsing

8 Answers
16622 Views
AON, Genpact, I also Faced
E-Mail Answers

Answer Posted / sureshramsing

select * from(select e.* from emp e order by sal desc) where rownum=1;

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

981

How does recursive cte works in sql server?

982

What are the character string functions supported by sql server 2005?

987

Why should one not prefix user stored procedures with ‘sp_’?

1021

Can group by and orderby be used together?

993

Can we perform backup restore operation on tempdb?

990

How to access the inserted record of an event?

1026

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

What does null mean?

970

Why we use functions in sql server?

1052

Please differentiate between a local and a global temporary table?

982

Does partitioning help performance?

918

What it means to be triggered?

962

What is RMS migrations?

2120

What is primary key index?

962