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
4279 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 difference between ms sql and mysql?

963

What mean sql?

1007

Can ddl statements be used in pl/sql?

1142

What is a behavioral trigger?

972

What is the benefit of foreign key?

1022

what is 'mysqldump'? : Sql dba

1108

Can you join a table to itself?

1130

How do I send sql query results to excel?

1066

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1115

How many triggers can be applied on a table?

933

Is it possible for a table to have more than one foreign key?

1030

Differentiate pl/sql and sql?

1064

What is on delete restrict?

1000

What is the usage of sql functions?

1146

how to include character strings in sql statements? : Sql dba

1071