Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

0 Answers  

---

How to write a left outer join with the where clause in oracle?

0 Answers  

---

waht is referencial integrity?

2 Answers   Semantic Space,

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

0 Answers  

---

What happens to the current transaction if the session is killed?

0 Answers  

---

Can you assign multiple query result rows to a variable?

0 Answers  

---

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

0 Answers  

---

Find all employees in Dept “Marketing”.

2 Answers  

---

9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,

---

Difference between inner join vs where ?

0 Answers  

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---