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 a sql driver?

985

Can a table have no primary key?

1038

how to shutdown mysql server? : Sql dba

1081

what are aggregate and scalar functions? : Sql dba

1040

how to install mysql? : Sql dba

1090

What is the maximum number of columns in sql table?

1150

How do I save a stored procedure?

992

What is a procedure in pl sql?

1194

What is the plv (pl/vision) package offers?

1029

Can we create table inside stored procedure?

939

Should I use mbr or gpt?

1011

Is trigger a stored procedure?

921

What are all types of user defined functions?

1055

What are the differences between implicit and explicit cursors?

1049

how to dump a table to a file with 'mysqldump'? : Sql dba

1022