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  

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

Is not null in sql?

0 Answers  

---

what is autonomouse transaction?

3 Answers   Oracle,

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

How many postgresql users are there, worldwide?

0 Answers  

---

How can we avoid duplicating records in a query?

0 Answers  

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

what is the difference between nested subquery and correlated subquery?

0 Answers  

---

Why use triggers in sql?

0 Answers  

---