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 is oltp (online transaction processing)? : Sql dba

1129

how to install mysql? : Sql dba

1161

Why is the cursor important?

1079

What trigger means?

1036

What is dcl in sql?

1024

Can a select statement fire a trigger?

1209

What is mdf ldf and ndf?

1058

Can delete statement be rollbacked?

1032

What language is oracle sql developer?

1071

What are the different type of joins in sql?

998

how can we find the number of rows in a table using mysql? : Sql dba

1129

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1172

What are the three pl sql block types?

1049

How can I speed up sql query?

1008

How do I sort a table in sql?

1083