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
- 9603 Views
- I also Faced
- E-Mail Answers
Answer Posted / xyz
aLTER TABLE emp ADD CONSTRAINT C3 CHECK (EMPNO < 300)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
how can we know the count/number of elements of an array? : Sql dba
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Write a query to display the current date in sql?
What is the difference between instead of trigger and after trigger?
What is an inconsistent dependency?
Can you have a foreign key without a primary key?
What is optimistic concurrency control? : Transact sql
how to rename an existing column in a table? : Sql dba
How many commands are there in sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
explain normalization concept? : Sql dba
Are sql database names case sensitive?
Is it possible for a table to have more than one foreign key?
What is synonyms?
How do you write an index?
