aLTER TABLE emp ADD CONSTRAINT C3 CHECK (EMPNO

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 / xyz

6 Answers
11368 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

Please Help Members By Posting Answers For Below Questions

What is pl sql block in dbms?

1000

What is foreign key in sql with example?

926

what are myisam tables? : Sql dba

1030

What is a sql driver?

995

What is nvl?

1061

What is on delete restrict?

998

What are the different schemas objects that can be created using pl/sql?

1017

Explain how exception handling is done in advance pl/sql?

996

What is the use of prepared statement?

1007

How does an execution block start and end in pl sql?

950

Why select is used in sql?

1013

How to revise and re-run the last sql command?

1161

Can you have a foreign key without a primary key?

951

Is sql low level language?

1014

Can a table contain multiple primary key’s?

1096