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

Why truncate is faster than delete?

1055

What is the difference between sql and t sql?

966

Why do we use sql constraints?

1124

What are the different types of database management systems?

951

Is sql workbench free?

932

Can we join same table in sql?

964

Explain what is dbms?

990

what are the t string functions available in tsql? : Transact sql

948

How do I access sql anywhere database?

921

What is pivot query?

1015

what is msql? : Sql dba

943

What is sql not null constraint?

983

How much ram can sql express use?

934

What is sql and explain its components?

1009

Can we insert data in view?

892