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

What are inbuilt functions in sql?

1014

How subquery works in sql?

1020

Explain autonomous transaction.

1125

What do you think about pl/sql?

974

What is over () in sql?

913

What steps server process has to take to execute an update statement?

945

Which is better join or inner query?

989

what are the different tables present in mysql? : Sql dba

942

What are the types of index in sql?

1037

What is pl sql package?

1006

how many sql dml commands are supported by 'mysql'? : Sql dba

1079

Explain locks? : Transact sql

974

What are the triggers associated with image items?

1014

what is the difference between delete and truncate statement in sql? : Sql dba

1171

What are types of exception?

892