Answer / Parul Sonker

In SQL, a JOIN is used to combine rows from two or more tables based on a related column between them. There are several types of joins including INNER JOIN (returns only the matching rows), LEFT JOIN (returns all rows from the left table and the matching rows from the right table), RIGHT JOIN (returns all rows from the right table and the matching rows from the left table), and FULL OUTER JOIN (returns all rows from both tables, including non-matching rows).

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

---

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

3 Answers  

---

what is difference between delete and truncate commands? : Sql dba

1 Answers  

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

What is the purpose of the partition table?

1 Answers  

---

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

---

Which table is left in left join?

1 Answers  

---

What does the hierarchical profiler does?

1 Answers  

---

What is relationship? How many types of relationship are there?

1 Answers  

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

1 Answers  

---

What is difference between rank () row_number () and dense_rank () in sql?

1 Answers  

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---