SELECT * FROM TABLE_NAME WHERE ROWNUM=1

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

2 Answers
4096 Views
I also Faced
E-Mail Answers

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 is left join example?

891

Does a user_objects view have an entry for a trigger?

963

What found sql?

898

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

972

What is sql not null constraint?

983

What are character functions?

1043

What is a system versioned table?

932

Is coalesce faster than isnull?

909

How many sql commands are there?

1073

How do I access sql anywhere database?

921

What is the use of index in hive?

963

how many ways we can we find the current date using mysql? : Sql dba

1039

What is pl sql code?

995

What is record in pl sql?

1011

What is a column in a table?

1064