1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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 do I order columns in sql?

532

What is the difference between nested table and varray?

524

What does select * from mean in sql?

2002

What is structural independence and why is it important?

551

What is user defined functions?

580




Can %notfound return null after a fetch?

593

What are the dml statements?

689

What is delete command in sql?

558

Can dml statements be used in pl/sql?

581

how can you create an empty table from an existing table? : Sql dba

663

Does inner join return duplicate rows?

521

What is the difference between union and union all command?

555

Explain the difference between drop and truncate commands in sql?

536

Can we change the table name in sql?

532

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

586