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

how do you restrict number of rows for a particular value
in a column.For example:there is a table called
fruits,having apples,bananas ,papayas.I dont want to have
more than 100 apples in that table ,so how can u restrict
number of rows for apple to hundred?

Answer Posted / guest

hint:using row level and statement level trigger

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of double ampersand (&&) in sql queries? Give an example

1139


Is it possible to create startup or shutdown trigger for on-schema?

1029


What is package in pl sql with an examples?

1035


What is the primary key?

952


What is the difference between null value, zero, and blank space?

1204


tell us something about heap tables. : Sql dba

1098


what is a trigger in mysql? : Sql dba

1146


What steps server process has to take to execute an update statement?

975


How do I add a primary key to a table?

1042


What is a pragma statement?

1262


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

952


Why does sql need a server?

1039


What is mutating table error?

1179


How do I count rows in sql query?

988


explain what is mysql? : Sql dba

1080