Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / gouri sankar

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

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

what are the security recommendations while using mysql? : Sql dba

0 Answers  

What is the difference between left and left outer join?

0 Answers  

How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

what is the bond code in materialized view?

0 Answers  

Is oracle and sql same?

0 Answers  

What is union and union all keyword in sql?

0 Answers  

What are the subsets of sql?

0 Answers  

How can I get the number of records affected by a stored procedure?

0 Answers  

What are the two types of exceptions in pl/sql?

0 Answers  

how to load data files into tables with 'mysqlimport'? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories