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

What is user defined functions?

915

Is sql workbench free?

929

Can a table contain multiple primary key’s?

1041

what is the difference between myisam static and myisam dynamic? : Sql dba

1002

How many types of literals are available in pl sql?

1045

What are different types of functions in sql?

955

What is count * in sql?

935

How do I find duplicates in the same column?

997

How do you delete a table?

997

How do I clear the screen in sql plus?

982

What are the disadvantages of file system?

1163

What is indexes?

1000

What is trigger and types?

965

Explain cursor types?

955

Is and as keyword in pl sql?

904