Why having clause is used in sql?

0 Answers  

---

What is the maximum number of triggers, you can apply on a single table?

0 Answers  

---

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

---

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

0 Answers  

---

I 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.

7 Answers   MTS,

---

Which is faster count (*) or count 1?

0 Answers  

---

which operator is used in query for pattern matching? : Sql dba

0 Answers  

---

What is attribute indicator in pl sql?

0 Answers  

---

differentiate between float and double. : Sql dba

0 Answers  

---

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

---