Sign Up Login


  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

What does truncate mean in sql?

731

Explain the working of foreign key?

731

Does truncate release storage space?

775

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

800

What is lexical units in pl sql?

771

What are all ddl commands?

746

Explain the uses of a database trigger?

788

What is a unique key and primary key and foreign key?

753

What is db journal file?

695

Can we rollback truncate?

723

What is the difference between a database and a relational database?

773

What are three advantages to using sql?

741

What is a trigger in sql?

899

What is constant in pl sql?

721

What are the triggers associated with image items?

800