how to retrieve the top 2 salaried persons from a database?
Answer Posted / abc
Select salary from (select salary from employees order by
salary desc) where rownum <=2;
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is snowflake sql?
How do I run a program in pl sql?
What is a delimiter in sas?
What is cursor and why it is required?
What are the different dcl commands in sql?
What are the types of subqueries?
Can I create table without primary key?
What does desc stand for?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
what is self-join? : Sql dba
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Which one is better sql or oracle?
How to create an array in pl/sql?
what is the difference between delete and truncate commands? : Sql dba
What is raw datatype in sql?