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  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

Is inner join same as self join?

0 Answers  

---

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

Is sqlite good enough for production?

0 Answers  

---

Is sql port 1433 encrypted?

0 Answers  

---

What is user defined functions?

0 Answers  

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

Compare sql & pl/sql

0 Answers  

---

Is sql free?

0 Answers  

---

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

---