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?

6 Answers  

---

How to get help at the sql prompt?

0 Answers  

---

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

---

What is secondary key?

0 Answers  

---

How much does a sql dba make? : SQL DBA

0 Answers  

---

What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

---

How do you define a foreign key?

0 Answers  

---

What is a system versioned table?

0 Answers  

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  

---

Does sqlite need a server?

0 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

---