SELECT EMP_BASICS,ROWNUM FROM EMPLOYEE_MASTER WHERE EMP

how to retrieve the top 3 salaries of the table using rownum

Question Posted / raveendran

Answer Posted / raveendran

SELECT EMP_BASICS,ROWNUM FROM EMPLOYEE_MASTER WHERE
EMP_BASICS IS NOT NULL AND ROWNUM<=3 ORDER BY EMP_BASICS
DESC

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to call a javascript function from pl sql?

1143

What mean sql?

1014

What is pl/sql table? Why is it used?

1045

What is bind variable in pl sql?

1054

what are the difference between clustered and a non-clustered index? : Sql dba

1033

Is left join same as inner join?

1131

How to read/write files from pl/sql?

1036

What are the different dcl commands in sql?

1174

How do you write an inner join query?

953

Why is a trigger used?

943

Why coalesce is used in sql?

1012

What are literals in sql server?

1170

What is trigger types of trigger?

1070

Explain the uses of database trigger.

1115

What is a parameter query?

1084