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 |
Is postgresql a nosql database?
how to use regular expression in pattern match conditions? : Sql dba
What is sql key?
How do you explain an index number?
How do I add a database to sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is the fastest way of accessing a row in a table?
Is sql harder than python?
How to return more than one value from a function?
What is the reports view in oracle sql developer?
What are the different types of constraints?
How does rowid help in running a query faster?
Oracle (3253)
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)