Answer / arun anoop m

We use Self Join, if we have a table that references itself.


For example, In the Employee Table below MANAGERID column
references EMPLOYEEID column. So the table is said to
referencing itself.This is the right scenario where we can
use Self Join.

What is difference between temp table and cte?

0 Answers  

---

What is cursors? And what are the different types of cursor?

0 Answers  

---

What is etl - extraction, transformation, and loading?

0 Answers  

---

What is a materialized view?

3 Answers  

---

What is the purpose of using COLLATE in a query?

1 Answers  

---

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

---

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

---

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

---

What are the properties of the relational tables?

0 Answers  

---

What is difference between Triggers and store procedure?

2 Answers  

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---