What are aggregate functions in sql?

0 Answers  

---

what is schema? : Sql dba

0 Answers  

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

---

How does a trigger work?

0 Answers  

---

What is the difference among union, minus and intersect?

0 Answers  

---

---

Can we rename a column in the output of sql query?

0 Answers  

---

what is hash join

1 Answers   NCR,

---

What is difference between sql function and stored procedure?

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

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  

---

Is sqlite good enough for production?

0 Answers  

---