how to retrieve the top 2 salaried persons from a database?
Answer Posted / rajkumar
select top 1 colmn from table_name where colmn in
(select top 2 colmn from table_name where colmn is not
null order by colmn desc)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is anonymous block in sql?
Explain the difference between rename and alias?
Which kind of parameters cannot have a default value in pl sql?
What is numeric function sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
Can 2 queries be executed simultaneously in a distributed database system?
How to Execute a Package in PL/SQL.?
How can I delete duplicate rows?
What is the maximum rows in csv?
What are pl sql procedures?
When should I use nosql database?
What is nosql vs sql?
What types of commands can be executed in sql*plus?
what is a trigger in mysql? : Sql dba
Can two tables have same primary key?