select salary from salary_table where rownum <4 order by salary desc

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

Question Posted / manivasan.s.,

Answer Posted / manivasan.s.,

select salary from salary_table
where rownum <4
order by salary desc

Is This Answer Correct ?

2 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1007

What is your daily office routine?

2273

Explain the advantages and disadvantages of stored procedure?

1150

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1142

What does cursor do in sql?

1028

How do I edit a trigger in sql developer?

999

What are different types of sql commands?

1118

What is pl sql commands?

1049

What is minus?

1005

What do you mean by stored procedures? How do we use it?

996

In a distributed database system, can we execute two queries simultaneously?

1095

What are few of the schema objects that are created using PL/SQL?

1039

what is union, minus and interact commands? : Sql dba

1187

Explain what is an index?

1059

what is the difference between $message and $$message? : Sql dba

1001