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

Explain the components of sql?

1104

What is compound trigger?

1095

How do I truncate a word?

1155

Is sql port 1433 encrypted?

1082

What is pl sql code?

1098

What is the difference between drop and truncate commands?

1107

what is cursor. write example of it. What are the attributes of cursor.

1460

what is 'mysqlimport'? : Sql dba

1104

What is right join in sql?

1150

Why do we use sql constraints?

1210

What is primary key and foreign key with example?

979

what are date and time data types? : Sql dba

1021

List and explain the different types of join clauses supported in ansi-standard sql?

1400

how to get a list of all tables in a database? : Sql dba

1026

what is a tablespace? : Sql dba

1098