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 / gk

We can use Check constraint to restict the values of any
column.

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define union, minus, union all, intersect ?

997


define sql insert statement ? : Sql dba

1019


Explain the working of primary key?

1089


Who is the owner of mysql database?

1055


How many functions are there in sql?

1011


What is sql and db2?

994


what is the difference between a local and a global temporary table? : Sql dba

1068


What is a pdo connection?

1025


How long does it take to learn pl sql?

1055


what are the advantages a stored procedure? : Sql dba

973


How do temporal tables work?

952


how can we optimize or increase the speed of a mysql select query? : Sql dba

938


is it possible to pass an object or table to a procedure as an argument?

1123


What is procedure explain with program?

1015


What is dml statement?

949