SELECT * FROM TABLE_NAME WHERE ROWNUM=1

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 / prativa mishra

2 Answers
4250 Views
I also Faced
E-Mail Answers

Answer Posted / prativa mishra

SELECT * FROM TABLE_NAME WHERE ROWNUM=1

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how do you tune the slow running queries in oracle db , explain the methodology

2581

how to escape special characters in sql statements? : Sql dba

1017

Why truncate is faster than delete?

1089

What is rank () in sql?

926

What is record type in pl sql?

977

describe mysql connection using mysql binary. : Sql dba

1047

How many databases can sql express handle?

968

How does cross join work in sql?

1001

Explain what is table in a database?

1045

what is a relationship and what are they? : Sql dba

1075

What is rank dense_rank and partition in sql?

1006

What are the various restrictions imposed on view in terms of dml?

957

What is difference between table and view?

1033

What is offset in sql query?

1092

What is sql catalog?

1000