Answer Posted / ramya

CREATE TABLE EMPLOYEE(

[EMPLOYEE_ID] INT PRIMARY KEY,

[NAME] NVARCHAR(50),

[MANAGER_ID] INT

)



INSERT INTO EMPLOYEE VALUES(101,'Mary',102)

INSERT INTO EMPLOYEE VALUES(102,'Ravi',NULL)

INSERT INTO EMPLOYEE VALUES(103,'Raj',102)

INSERT INTO EMPLOYEE VALUES(104,'Pete',103)

INSERT INTO EMPLOYEE VALUES(105,'Prasad',103)

INSERT INTO EMPLOYEE VALUES(106,'Ben',103)


select e1.employee_id,e1.name,e1.manager_id,e2.name from
employee e1 join employee e2
on e1.employee_id = e2.manager_id

What is DB Development software?

2067

---

How to read and create .LDC data files which are used by linguatic dictionary.

2527

---

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.

2050

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1058

---

How to customize error conditions.

2140

---

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

1105

---

How can you fix a poorly performing query?

1172

---

How can I detect whether a given connection is blocked?

1043

---

What are the key features of dbms?

983

---

Explain about a primary key?

974

---

Explain about post-relational databases?

1013

---

Explain about the relational database?

1062

---

Who are naive users?

995

---

What are the types of database model?

1077

---

Explain the role of indexing in databases?

1120

---