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

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

Question Posted / gouri sankar

3 Answers
8170 Views
Exilant, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / srinivas

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

Is This Answer Correct ?

29 Yes

6 No

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

Answer / ashok kumar lenka

We can solve this by the help of Trigger.
The trigger is for update.which store the update time of the
record of the table. So my query is like this
>select * from emp where to_char(update_column,'dd')=2;

Is This Answer Correct ?

10 Yes

5 No

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

Answer / narenkumar reddy

select column_name from table_name
where column_name=sysdate-2

Is This Answer Correct ?

1 Yes

2 No

Post New Answer