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

Is sql a backend language?

1102

What can you do with pl sql?

1106

What are different types of sql?

1200

what is msql? : Sql dba

996

What is trigger explain with example?

1048

How do you remove duplicate records from a table?

949

What is the current version of postgresql?

1074

What is the life of an sql statement?

1033

How can you view the errors encountered in a trigger?

969

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1076

What are the uses of merge?

1175

When is the update_statistics command used?

1131

What is sql basics?

1048

Can I create table without primary key?

1005

Is left join inner or outer?

1033