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
Define union, minus, union all, intersect ?
define sql insert statement ? : Sql dba
Explain the working of primary key?
Who is the owner of mysql database?
How many functions are there in sql?
What is sql and db2?
what is the difference between a local and a global temporary table? : Sql dba
What is a pdo connection?
How long does it take to learn pl sql?
what are the advantages a stored procedure? : Sql dba
How do temporal tables work?
how can we optimize or increase the speed of a mysql select query? : Sql dba
is it possible to pass an object or table to a procedure as an argument?
What is procedure explain with program?
What is dml statement?