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  

---

What is rank function in sql?

0 Answers  

---

Are sql views compiled?

1 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---

What is Collation Sensitivity ? What are the various type ?

0 Answers  

---

What is the difference between syntax error and runtime error?

0 Answers  

---

How many types of normalization are there?

0 Answers  

---

How can you fetch common records from two tables?

0 Answers  

---

Why join is faster than subquery?

0 Answers  

---

How to order siblings in oracle hierarchy queries?

0 Answers  

---

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers  

---

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

---