Can we create a trigger on view?

0 Answers  

---

What is difference between inner join and self join?

0 Answers  

---

What is difference between function and trigger?

0 Answers  

---

what is rollback? : Sql dba

0 Answers  

---

Which tcp/ip port does sql server run?

0 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

How do you create a db file?

0 Answers  

---

What is query optimization in sql?

0 Answers  

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

0 Answers  

---

what is the order of pre-defined exceptions.

6 Answers   TCS,

---

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

---