how to retrieve the top 2 salaried persons from a database?
- 7 Answers
- 7770 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
What is raid? How does it help storage of databases?
what is the difference between primary key and unique key? : Sql dba
how to convert dates to character strings? : Sql dba
What are string functions in sql?
What is java sql connection?
What are the types of sql commands?
List and explain the different types of join clauses supported in ansi-standard sql?
Explain the types of joins in sql?
What are different types of keys?
What is count * in sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How show all rows in sql?
Can pl sql procedure have a return statement?
What is composite primary key in sql?
Why do we use procedures in pl sql?
