table structure: ---------------- col1 col2 -----

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 / sushma s

2 Answers
3361 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

table structure: ---------------- col1 col2 ----- ----- 01..

Answer / prativa mishra

SELECT * FROM TABLE_NAME WHERE ROWNUM=1

Is This Answer Correct ?

1 Yes

0 No

table structure: ---------------- col1 col2 ----- ----- 01..

Answer / hai

select * from table_name where rownum<2;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers Tech Mahindra,

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers

Why are cursors used?

0 Answers

is it possible to pass an object or table to a procedure as an argument?

0 Answers

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers

How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers

What is int identity in sql?