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

What is the process of debugging?

1134

What is natural join in sql?

1052

What is cursor and why it is required?

1259

How do I count records in sql?

1061

Is it possible to pass parameters to triggers?

1169

How to load data with sql*loader?

1114

What is partition in sql query?

1050

Can we write ddl statements in functions?

1187

How do I upgrade sql?

1053

difference between anonymous blocks and sub-programs.

1190

What is cursor status?

1244

what is bcp? When is it used?

1189

What are predefined functions in sql?

1117

What are the most important characteristics of pl/sql?

1238

What is difference between sql and mysql?

1211