We can use Check constraint to restict the values of any column.

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?

Question Posted / gk

6 Answers
11637 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are the different types of a subquery?

1113

How do I run a program in pl sql?

1057

What is sql scripting?

1199

What is a left join?

1011

How does rowid help in running a query faster?

1478

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1247

How do you declare a constant?

1019

Is sql a case sensitive language?

1010

What is the default isolation level in sql server? : Transact sql

1091

Is primary key always clustered index?

1069

What is sqlcontext?

1148

How to use boolean type in select statement?

1144

What type of join is sql join?

1027

What is the basic form of sql query?

997

How to write pl sql program in mysql command prompt?

1167