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?
- 6 Answers
- 11638 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
What are dml commands?
how would you enter characters as hex numbers? : Sql dba
How would you convert date into julian date format?
what is the difference between char_length and length? : Sql dba
How can we implement rollback or commit statement in a trigger?
What is a natural join sql?
What are the possible values that can be stored in a boolean data field?
Can we rollback after truncate?
Explain the difference in execution of triggers and stored procedures?
What is sql and also describe types of sql statements?
What are the limitations of sql express?
what is the difference between clustered and non clustered index in sql? : Sql dba
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What are the rules to be applied to nulls whilst doing comparisons?
who introduced sql?
