how to retrieve the top 3 salaries of the table using rownum
Answers were Sorted based on User's Feedback
Answer / vivek dubey
select salary_column from salary_table
where rownum<4
order by salary_column desc
| Is This Answer Correct ? | 24 Yes | 42 No |
Are stored procedures compiled?
Is it important to partition hard disk?
Explain Connect by Prior?
What is the difference between stored procedure and view?
How do I run a pl sql procedure in sql developer?
Which is better join or subquery?
What are the types of variables use in pl sql?
What is auto increment?
Which join is default?
How do you clear the screen in sql?
What are Nested Tables? How will u delete 5 rows from Nested Tables
explain the difference between myisam static and myisam dynamic. : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)