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
4459 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 rename an existing column in a table? : Sql dba

1079

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116

What is natural join in sql?

1044

What does inner join mean?

1260

What problem one might face while writing log information to a data-base table in pl/sql?

1247

what are the differences between binary and varbinary? : Sql dba

1084

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1115

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

998

What is embedded sql what are its advantages?

1108

How to make a copy values from one column to another in sql?

1080

What type of database is cloud sql?

1157

How do I run a sql query?

1080

What is primary and foreign key?

1122

How do I trace sql profiler?

1042

How can you save or place your msg in a table?

1039