how to retrieve the top 2 salaried persons from a database?
- 7 Answers
- 8522 Views
- Orion Laboratories, I also Faced
- E-Mail Answers
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
How does sql profiler work?
How to know the last executed procedure?
What is the difference between the sql*loader and import utilities? : aql loader
What are the two types of exceptions in pl/sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
How do I run a program in pl sql?
What are the different tcl commands in sql?
Can you join views in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Is left join inner or outer by default?
What is the use of partition by in sql?
Explain what is table in a database?
What is the sql case statement?
Explain what is a column in a table?
What are the basic sql commands?
