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 / xyz
aLTER TABLE emp ADD CONSTRAINT C3 CHECK (EMPNO < 300)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Does postgresql run on the cloud?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is pessimistic concurrency control? : Transact sql
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Explain unique key in sql.
Can there be 2 primary keys in a table?
What are expressions?
Can you have more than one key in a database?
What is a rank in sql?
How to use distinct and count in sql query? Explain
What is dml with example?
What are hotfixes and patches?
What are actual parameters and formal parameters?
What is normalization sql?
What is the difference between clustered and non-clustered index in sql?