7. Repeat query (7) but also display all clients who have never ordered anything.

1 Answers   Wipro,

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

List out the types of joins.

0 Answers  

---

types of indexes and the rationale behind choosing a particular index for a situation.

0 Answers  

---

Explain the difference between a procedure and a function? What do you understand by those terms?

0 Answers  

---

Can you assign multiple query result rows to a variable?

0 Answers  

---

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 handle exceptions in post production

0 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

primary key is foreign key for the same table?

2 Answers   Oracle,

---

How to build data dictionary view an new database?

0 Answers  

---

How can we find the size of a database?

2 Answers  

---