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

What is group function in sql?

1013


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1200


Why we use joins in sql?

975


what is the use of double ampersand (&&) in sql queries?

1169


What is the non-clustered index in sql?

1056


Explain scalar functions in sql?

1059


What are the advantages of sql? Explain

1095


Which sorts rows in sql?

1013


What is autocommit sql?

981


What is the sql case statement?

992


What type of join is sql join?

978


What are tables and fields?

1027


what is a composite key ? : Sql dba

1045


What is a primary key? Explain

970


explain advantages of innodb over myisam. : Sql dba

1124