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
- 10336 Views
- I also Faced
- E-Mail Answers
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
Why is stored procedure faster than query?
What is sql engine in oracle?
Can you have a foreign key without a primary key?
How many types of primary keys are there?
what is sql server agent? : Sql dba
Show the cursor attributes of pl/sql.
How do you respond to dementia behavior?
How do I install microsoft sql?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is a subquery in sql?
Can we create table inside stored procedure?
How can I see all tables in sql?
What is pessimistic concurrency control? : Transact sql
What is use of trigger?
What is the difference between rename and alias?
