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?
- 6 Answers
- 9617 Views
- I also Faced
- E-Mail Answers
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
What are the possible values that can be stored in a boolean data field?
What is varchar example?
what are rollup and cube in t-sql? : Transact sql
Write a sql select query that only returns each name only once from a table?
Can we join more than 2 tables in sql?
How to add, remove, modify users using sql?
What is union, minus and interact commands?
How can a function retun more than one value in oracle with proper example?
When should I use nosql database?
how many values can the set function of mysql take? : Sql dba
What are different types of sql commands?
What is mdf ldf and ndf?
Which constraints we can use while creating database in sql?
what are sequences
How can the performance of a trigger be improved?
