Answer / Himanshu Chauhan

A recursive JOIN, also known as Common Table Expression (CTE), allows you to create a temporary result set that can be referenced later in the same SELECT statement. It enables you to perform self-joins or multiple-pass joins within a single SQL statement.

What are local and global Indexes and where they are useful.

1 Answers  

---

Can we use distinct and group by together?

0 Answers  

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

Explain what is a field in a database and record in a database?

1 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

1 Answers   IBM,

---

Why are indexes and views important to an organization?

1 Answers  

---

How will we see framework of a table?

2 Answers   Accenture,

---

what is the difference between implicit conversions and explicit conversions?

2 Answers  

---

What is the difference between sql and t sql?

1 Answers  

---

How can we find duplicate records in a table?

1 Answers  

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

Why is stored procedure faster than query?

1 Answers  

---