what is isam? : Sql dba

0 Answers  

---

What is difference between cursor and ref cursor?

1 Answers  

---

Can we use ddl statements in stored procedure?

0 Answers  

---

What are the key differences between SQL and PL SQL?

0 Answers  

---

how do you know if your mysql server is alive? : Sql dba

0 Answers  

---

---

What are its different types of dbms?

0 Answers  

---

what is sql.

6 Answers   Ericsson, Hewitt,

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

What are the different ways to optimize a sql query?

0 Answers  

---

Can we rename a column in the output of sql query?

0 Answers  

---

what is msql? : Sql dba

0 Answers  

---