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
4287 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 will you get by the cursor attribute sql%rowcount?

1038

What is join view in sql?

945

Can we insert in sql function?

1088

What are tables and fields in the database?

1112

Can we rename a column in the output of sql query?

995

What is user defined functions?

984

how to include numeric values in sql statements? : Sql dba

1100

Is drop table faster than truncate?

990

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1075

What is dcl in sql?

961

What are string functions in sql?

1243

How do you modify a table in sql?

1126

What is an intersect?

1103

What are the uses of merge?

1167

Why is %isopen always false for an implicit cursor?

1107