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

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

How do I find duplicates in sql?

0 Answers  

What is nvarchar max in sql?

0 Answers  

What is keys and its types?

0 Answers  

What are the two characteristics of a primary key?

0 Answers  

How is debugging done?

0 Answers  

What is the purpose of the primary key?

0 Answers  

what are the disadvantages of mysql? : Sql dba

0 Answers  

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

What are the types of triggers in sql?

0 Answers  

How sql query is executed?

0 Answers  

What is record variable?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories