What is the difference between inner join and left join?

0 Answers  

---

how mysql optimizes distinct? : Sql dba

0 Answers  

---

what are date and time data types? : Sql dba

0 Answers  

---

Is json a nosql?

0 Answers  

---

What is pl sql in oracle?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

How do I add a primary key to a table?

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,

---

What is pivot in sql?

0 Answers  

---

How to look at the current sql*plus system settings?

0 Answers  

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  

---

define sql

3 Answers   Zensar,

---