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
How do sql triggers work?
how to install mysql? : Sql dba
How do I find duplicates in the same column?
What is pl sql block in dbms?
Is there a way to automate sql execution from the command-line, batch job or shell script?
what is datawarehouse? : Sql dba
How do I copy a table in sql?
Explain the commit statement.
Can we insert data into materialized view?
What does bitemporal mean?
What are the operators in sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is memory optimized table?
Can we insert delete data in view?
what are the 'mysql' command line options? : Sql dba