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

Enlist the data types that can be used in pl/sql?

1116

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1015

What is a primary key sql?

1097

Why should I use postgresql?

1070

what are the difference between clustered and a non-clustered index? : Sql dba

1094

What are string functions in sql?

1308

What do you understand by pl/sql records?

1072

Is sql sequential or random?

1091

What is the max nvarchar size?

1037

How exception handling is done in advance pl/sql?

1030

How do you modify a column in sql?

1059

Can we create a trigger on view?

956

Is pl sql useful?

1041

What is sqlcontext?

1151

Mention what does the hierarchical profiler does?

1150