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...

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql better than access?

1014


what is log shipping? : Sql dba

1113


What is localdb mssqllocaldb?

1066


How does postgresql compare to "nosql"?

1029


What are the basic sql commands?

1090


How do you add a column to a table?

1055


How do I send sql query results to excel?

1066


Explain the difference between triggers and constraints?

972


What is group function in sql?

1020


Can primary key be changed?

903


What is replication id?

935


What does select * from mean in sql?

3233


What is auto increment in sql?

1119


Should I use mbr or gpt?

1024


What is lexical units in pl sql?

1146