table structure:
----------------
col1 col2
----- -----
01-mar-2012 11:12:46 01-mar-2012 11:12:10
01-mar-2012 11:12:46 01-mar-2012 11:11:23
Write a query to display the result as shown below:
col1 col2
----- -----
01-mar-2012 11:12:46 01-mar-2012 11:12:10
Answer Posted / prativa mishra
SELECT * FROM TABLE_NAME WHERE ROWNUM=1
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how do you tune the slow running queries in oracle db , explain the methodology
how to escape special characters in sql statements? : Sql dba
Why truncate is faster than delete?
What is rank () in sql?
What is record type in pl sql?
describe mysql connection using mysql binary. : Sql dba
How many databases can sql express handle?
How does cross join work in sql?
Explain what is table in a database?
what is a relationship and what are they? : Sql dba
What is rank dense_rank and partition in sql?
What are the various restrictions imposed on view in terms of dml?
What is difference between table and view?
What is offset in sql query?
What is sql catalog?