how to calculate the difference between two dates? : Sql dba

0 Answers  

---

Do we need commit after truncate?

0 Answers  

---

What is the difference between clustered and non-clustered indexes?

0 Answers  

---

what is self join and why is it required? : Sql dba

1 Answers  

---

Is id a reserved word in sql?

0 Answers  

---

What is benefit of creating memory optimized table?

0 Answers  

---

Is primary key clustered or nonclustered?

0 Answers  

---

What sql does db2 use?

0 Answers  

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

What is union?

0 Answers  

---

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,

---