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 transaction control language (tcl)?
Can we use distinct and group by together?
What is dynamic query?
how to decrement dates by 1 in mysql? : Sql dba
Can you select everything, but 1 or 2 fields, without writer's cramp?
Which join is default?
What are schema-level triggers?
How would you pass hints to the sql processor?
what is not null constraint? : Sql dba
What is sql and also describe types of sql statements?
what is 'mysqlshow'? : Sql dba
How do you create a unique index?
How can you select unique records from a table?
What are the topics in pl sql?
How to change sql*plus system settings?