select * from <table name> where rownum<=2 order by last

in table there r so many rows write a query which two rows r
updated last two day befor?

Question Posted / srinivas

Answer Posted / srinivas

select * from <table name>
where rownum<=2
order by last_updated_date

Is This Answer Correct ?

29 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What are dml commands?

1016

How do I run sql profiler?

1059

Can a foreign key have a different name?

940

What is primary key secondary key alternate key candidate key?

1031

Mention what does plv msg allows you to do?

1107

In a distributed database system, can we execute two queries simultaneously?

1081

What is the function that is used to transfer a pl/sql table log to a database table?

1006

How delete all data from table in sql?

1014

How does join work in sql?

1006

What is transaction control language (tcl)?

1130

Why does sql need a server?

1031

How does sql profiler work?

1011

how many sql dml commands are supported by 'mysql'? : Sql dba

1113

What are the possible values that can be stored in a boolean data field?

996

What is sql profiling in oracle?

1056