Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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



More SQL PLSQL Interview Questions

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,


What is not null in sql?

0 Answers  


Can we use loop in sql?

0 Answers  


In what condition is it good to disable a trigger?

0 Answers  


Why left join is used in sql?

0 Answers  






How can analyze query after generating explain plan ?

2 Answers   Thermotech,


How to call DDL statements from pl/sql?

5 Answers  


How is sql used in oracle?

0 Answers  


What is the difference between subquery and correlated query?

0 Answers  


Is primary key an index?

0 Answers  


How to use distinct and count in sql query? Explain

0 Answers  


Which are sql * plus commands?

0 Answers  






Categories