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

Which data type is a composite type?

991

What program will open a mdb file?

969

Is nosql relational?

947

how to shut down the server with 'mysqladmin'? : Sql dba

1014

Why stored procedure is better than query?

948

How to get each name only once from an employee table?

1116

Is natural join same as inner join?

945

How to run pl sql program in mysql?

1025

What is an implicit commit?

1058

What are local and global Indexes and where they are useful.

1444

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

999

What do you understand by pl/sql cursors?

1090

how to use in conditions? : Sql dba

1014

How can I make sql query run faster?

1018

How to use distinct and count in sql query? Explain

1026