020 110 ,901008 . crrcr tcsie\" erret mn..1 r s m s e e s n erpioitti sprrcrnnr

Question

020 110 ,901008 . crrcr tcsie" erret mn..1 r s m s e e s n erpioitti sprrcrnnr *h-1 r e p . p e e p- etretrer@0@ r 1 sipt n e s e s l e e titi-tb nrnvens pmt@sepeabe- r" nna@r@ds@ amresc- 1 , moete. bhenm ergutbea," bi @eat.1 m @.j" rsa a1. aa taa“ ins mar," bd,ce- ipJR Ja-nah enePh rstgtt eiinnn gsnEie hs1ee nAJ P" pune"-" -, 4 4 3 3 3 , , ;" 3-3334. “ ,033" 4, ,43132 , , ,, " 2297 311-6 20490 3866-8 94657 9911069 099999000-39 949 99-99 9, 9999 9 9 91 9 11 ,2 -,-, n ;" 313 tmvTomle.1 at isa stTaDaacee e L JDMWg i yih ngd ralokyeyi hgnrilscavrr oaaasiailaat 454457444 336857338 222222126

Explanation / Answer

5) EXISTS query

Here, Employee and Database_table are two tables both have Employee details having "e" as Employee table alias name and "d" as Database_table alias name.
Query output is Eid and Ename from Employee table.

Query

SELECT Eid,Ename
FROM Employee e
where EXISTS (select Employee_id from Database_table d where d.Employee_id = e.Eid);

6) Inner join query

SELECT Ename,Phone_number FROM Employee INNER JOIN Database_table ON Employee.Eid = Database_table.Eid;

Here, Employee and Database_table are two tables both have Employee details, query output is to return employee name (Ename as column name) and phone number (Phone_number as column name) from Employee table having inner join with Database_table having "Eid" column has common in both tables as foriegn key constraint.

7) Right join Query

SELECT Ename,department_name FROM Employee RIGHT JOIN Departments ON Employee.Dept_id = Departments.Dept_id;

Here, Employee and Departments are two tables both have Employee and department details, query output is to return employee name (Ename as column name) and department name (department_name as column name), from Employee table(left table) having right join with Departments table (right table) having "Dept_id" column has common in both tables as foriegn key constraint.

Related Questions

Navigate

• Browse (All)
• Browse
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.