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
11610 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

Explain exception handling in pl/sql?

1080

What are inner and outer joins examples of both?

1009

What is pls integer?

1089

Is left join and outer join same?

1114

which tcp/ip port does sql server run on? : Sql dba

1078

What is the execution plan in sql?

1070

What is trigger types of trigger?

1139

Are pl sql variables case sensitive?

1091

Is sql open source?

1022

What plvcmt and plvrb does in pl/sql?

1363

What is t sql used for?

1057

What is the difference between sum and count in sql?

1033

What are the possible values that can be stored in a boolean data field?

1040

What is nvarchar in sql?

978

How would you pass hints to the sql processor?

1037