Answer Posted / mike

You lost one Anju as Employee , because Anju does not have a
manager.
You should use left outer join in this case.

select e1.emp_name 'manager',e2.emp_name 'employee'
from employees e1 left outer join employees e2
on e1.emp_id=e2.emp_manager_id

Explain about relational database management systems?

921

---

Write short notes on manual refreshes.

2685

---

What is database design and development?

955

---

Write the fastest query to find out how many rows exist in a table?

1063

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

1994

---

What is dbms and its application?

948

---

Explain about a primary key?

934

---

How would you design a database for an online site, which would average a million hits a day?

951

---

How to use timestamp datatypes

1970

---

fact table and dimension table containg one to many relationship or many to one relastionship

2448

---

Explain the cube operator?

940

---

How long can an error message be in raiseerror function?

948

---

What is normalization? Explain different levels of normalization?

62739

---

What are the constraints on severity level in raiseerror?

938

---

What are the main phases of database development?

923

---