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

Can you upgrade sql express to full sql?

1077

What is a trigger word?

1032

what is the difference difference between procedure and packages

10424

What is output spooling in sql*plus?

1041

What is a full join sql?

1063

Which normal form is best?

953

How many times can we commit in a loop?

1029

What is difference between inner join and cross join?

978

can a stored procedure call itself or recursive stored procedure? : Sql dba

1038

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

979

What is a clob in sql?

1027

What is the use of prepared statement?

1033

What is data types in sql?

1015

what is single byte over head in oracle..?

2412

What pl/sql package consists of?

1091