What is pivot query?

0 Answers  

---

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

---

Explain the update statement in sql

0 Answers  

---

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,

---

What is a cursor ? Why Cursor is required ?

3 Answers  

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

How do you bind variables in pl sql?

0 Answers  

---

What is the difference between a subquery and a join?

0 Answers  

---

what are the disadvantages of mysql? : Sql dba

0 Answers  

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

0 Answers  

---

what is the command line end user interface - mysql? : Sql dba

0 Answers  

---