select * from table_name where rownum<2;

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

Question Posted / hai

2 Answers
4465 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

Please Help Members By Posting Answers For Below Questions

What is a heap in sql?

1149

what are local and global variables and their differences? : Sql dba

1140

What is the difference between partitioning and sharding?

1053

What is update query?

1035

What is the difference between union and union all command?

1152

What are pl/sql packages?

1161

What is meant by cursor in sql?

1068

Where not exists in sql?

1033

How do I turn a list into a table?

1013

What is a database trigger?

1138

how to fetch common records from two tables? : Sql dba

1254

What is crud stand for?

1049

Is sql open source?

1026

What is the life of an sql statement?

1076

Which is faster truncate or drop?

1103