how to retrieve the top 2 salaried persons from a database?
Answer Posted / mamta
Select sal
from salary_tbl
where rownum <= 2
order by sal desc;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is meant by temporal data?
What can sql server reporting services do?
Is oracle and sql same?
what is the different between now() and current_date()? : Sql dba
Differentiate between pl/sql and sql?
how do you know the version of your mysql server? : Sql dba
How to run sql statements with oracle sql developer?
How would you convert date into julian date format?
What is varchar used for?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is difference between mysql and postgresql?
what is the bond code in materialized view?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Define concurrency control. : Transact sql
What is sorting in sql?