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 / 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
Compare sql & pl/sql
What are the differences between implicit and explicit cursors?
What is faster join or subquery?
What is sqlite format?
what is 'mysqldump'? : Sql dba
Is sql a scripting language?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Explain sql data types?
What is data profiling in sql?
Enlist the advantages of sql.
What does count (*) do in sql?
How can we debug in PL/SQL?
What are sql built in functions?
What does fetching a cursor do?
What is the purpose of using pl/sql?