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 is mutating table error?

650

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

544

how many triggers are allowed in mysql table? : Sql dba

550

Does sql view stored data?

527

how would you get the current date in mysql? : Sql dba

525

what is a record in a database ? : Sql dba

559

How do I run sql?

603

Write a sql query to convert all character to uppercase after hypen.

951

How does index help in query performance?

551

Can you selectively load only those records that you need? : aql loader

601

What are the subsets of sql?

541

Why use triggers in sql?

486

What is sqlexception in java?

538

How do I view a view in sql?

495

Is primary key clustered index?

510