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 does a self join work?

1232

How is data stored in sql?

1101

What is a heap in sql?

1140

Is left join same as inner join?

1216

What pl/sql package consists of?

1133

What is meant by cursor in sql?

1061

What is the difference between unique and primary key constraints?

1121

Why do we use subquery?

1074

What can sql server reporting services do?

1163

Does normalization improve performance?

1103

How to write pl sql program in mysql command prompt?

1164

How do I access sql anywhere database?

1022

what is a composite key ? : Sql dba

1101

what does myisamchk do? : Sql dba

1079

Enlist the data types that can be used in pl/sql?

1107