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
11215 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 do you mean by stored procedures? How do we use it?

955

Define the select into statement.

1010

How to write pl sql program in mysql command prompt?

1040

what are the differences among rownum, rank and dense_rank? : Sql dba

1006

What is the difference between a query and a report?

928

Why is %isopen always false for an implicit cursor?

1061

What is the use of sqldataadapter?

927

what is a materialized view? : Sql dba

1021

Explain the difference between rename and alias?

986

Why we use cross join?

913

Can a table have no primary key?

1023

Explain table and field in sql?

1033

What is a file delimiter?

1043

What are records give examples?

971

What is the advantage of index in sql?

927