select * from table_name where rownum<2;

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 / hai

2 Answers
4098 Views
I also Faced
E-Mail Answers

Answer Posted / hai

select * from table_name where rownum<2;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is view? Can we update view

1353

What is a data definition language?

1029

Is postgresql a nosql database?

1079

What is on delete restrict?

945

How does a trigger work?

990

What do you mean by rowid?

917

What are local and global variables and their differences?

1048

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

985

Is sql developer case sensitive?

945

Explain table and field in sql?

1017

How do you break a loop in pl sql?

989

what are the different type of sql's statements ? : Sql dba

874

What is dialect in sql?

890

Can you rollback after commit?

936

What are the benefits of pl sql?

1055