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 data modeling with example?

917

---

What are the types of database model?

1031

---

What are data modelling techniques?

904

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2811

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2165

---

What are the constraints on severity level in raiseerror?

940

---

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?

1013

---

Explain about post-relational databases?

960

---

What is dbms and its application?

949

---

What are the main phases of database development?

925

---

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

1068

---

How can you log an error to the server event log from a stored procedure?

1045

---

Explain what a database is?

987

---

Explain about the database management systems.

922

---

How to combine two function together?

2073

---