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
4246 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

Is stored procedure faster than query?

949

How to run pl sql program in mysql?

997

What is cascade in sql?

945

What are the different types of dbmss?

998

How to test for null values?

1023

Explian rowid, rownum? What are the psoducolumns we have?

985

How to run sql statements with oracle sql developer?

1047

how to get help information from the server? : Sql dba

915

How do I send sql query results to excel?

1048

What is mdb stand for?

992

Explain what is an index?

1034

What do you mean by field in sql?

1068

What are the features of pl sql?

1047

Why commit is not used in triggers?

1023

What is crud diagram?

927