Answer / nandini sett

Outer join displays result set containing all the rows from
one table and the matching rows from another table. There
are three types of Outer Join -- Left Outer Join (All rows
of the left table and matchng rows of the right), Right
Outer Join (All rows of the right table and matching rows
of the left table) and Full Outer Join (All rows of both
tables).
In self join, table is joined with itself. One row
correlates with other rows in the same table. Hence a table
name with two alias names is used.
Difference between outer join and self join is that outer
join uses atleast two or more tables where one column is
common while self join uses only one table and two fields
of the same table.
Cartesian Product or cross join is between two tables where
each row from one table with each row of the other table.
If table A has 5 rows and table B has 10 rows then after
cross join the total number of rows would be 50.

What is serial sql?

1 Answers  

---

What is tuple in sql?

1 Answers  

---

how tsql statements can be written and submitted to the database engine? : Transact sql

1 Answers  

---

How many types of relationship are there?

1 Answers  

---

What is insert command in sql?

1 Answers  

---

Write a query to get last 10 records from the table.

12 Answers   iNautix,

---

what are the differences between char and nchar? : Sql dba

1 Answers  

---

How do you select unique values in sql?

1 Answers  

---

What is scalar and vector?

1 Answers  

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1 Answers  

---

how to check myisam tables for errors? : Sql dba

1 Answers  

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1 Answers  

---