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
- 2 Answers
- 3717 Views
- I also Faced
- E-Mail Answers
Answer Posted / hai
select * from table_name where rownum<2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between subquery and correlated query?
how many values can the set function of mysql take? : Sql dba
Explain foreign key in sql?
What are the different tcl commands in sql?
what is the use of set statement in tsql? : Transact sql
Can I learn sql in a week?
What is scope and visibility in PL/SQL?
What is mutating sql table?
What are the different sql languages?
Why do we use cursors?
Why select is used in sql?
Is join and inner join the same?
What are predefined functions in sql?
What mean sql?
How does pl sql work?
