I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

Are stored procedures faster than dynamic sql?

0 Answers  

---

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

---

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

how can you create an empty table from an existing table? : Sql dba

0 Answers  

---

How many sql statements are used? Define them.

0 Answers  

---

What is a scalar value in sql?

0 Answers  

---

What are stored procedures in mysql?

0 Answers  

---

What are code pages ?

1 Answers   BirlaSoft,

---

Which sql most popular?

0 Answers  

---

what is oltp (online transaction processing)? : Sql dba

0 Answers  

---