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
4293 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 to include character strings in sql statements? : Sql dba

1081

What is raw datatype in sql?

1051

What is a function in oracle pl sql?

1045

how many sql ddl commands are supported by 'mysql'? : Sql dba

1030

How to take user input in pl sql?

1169

What is the use of sql trace?

960

How to rename a column in the output of sql query?

1073

How is a process of pl/sql compiled?

1172

Can we debug stored procedure?

1032

what is cursor. write example of it. What are the attributes of cursor.

1402

What are pl/sql packages?

1107

What is the left table in sql?

974

What is java sql package?

1099

What are predefined functions in sql?

1052

how to increment dates by 1 in mysql? : Sql dba

986