What are the types of subqueries?

0 Answers  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

---

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,

---

How can we debug in PL/SQL?

0 Answers  

---

What is a dynamic query?

0 Answers  

---

How does postgresql compare to oracle/db2/ms sql server/informix?

0 Answers  

---

How can you create an empty table from an existing table?

0 Answers  

---

Can u create a primary key with out unique index.

8 Answers  

---

how to create a new table in mysql? : Sql dba

0 Answers  

---

How do you write an inner join query?

0 Answers  

---