Easy method to find top 3 sal - Select distinct top 3 (sal) from emp or

select top 3 sal from each dept?

Question Posted / asksam

Answer Posted / asksam

Easy method to find top 3 sal -

Select distinct top 3 (sal) from emp order by sal desc

Is This Answer Correct ?

10 Yes

27 No

Please Help Members By Posting Answers For Below Questions

Differentiate pl/sql and sql?

1071

What are triggers and its types?

1080

what is the use of double ampersand (&&) in sql queries?

1178

How to fix oracle error ora-00942: table or view does not exist

1020

What is hibernate and its relation to sql?

1131

Are left and right joins the same?

1093

How do I run pl sql in sql developer?

1126

What is the difference between syntax error and runtime error?

1148

What is pls integer?

1054

What is the syntax and use of the coalesce function?

1179

Which join is like an inner join?

1033

discuss about myisam key cache. : Sql dba

1024

What is the difference between explicit and implicit cursors in oracle?

1073

How do I enable sql encryption?

1035

Which is better join or inner query?

1064