45 SQL Server Queries for Practice (1-20) - Part 1
Following is the Employee Table which contains the detail for the
Employee with department id and head id. Head of the employee is also an
another employee
Table:-Employee
EmpId
|
EmpName
|
Department
|
ContactNo
|
EmailId
|
EmpHeadId
|
101
|
Isha
|
E-101
|
1234567890
|
abc@yahoo.com
|
105
|
102
|
Priya
|
E-104
|
1234567890
|
abc@gmail.com
|
103
|
103
|
Neha
|
E-101
|
1234567890
|
abc@gmail.com
|
101
|
104
|
Rahul
|
E-102
|
1234567890
|
abc@ymail.com
|
105
|
105
|
abhishek
|
E-101
|
1234567890
|
abc@gmail.com
|
102
|
Table:-EmpDept
DeptId
|
DeptName
|
DeptHead
|
E-101
|
HR
|
105
|
E-102
|
Development
|
101
|
E-103
|
House Keeping
|
|
E-104
|
sales
|
104
|
E-105
|
purchase
|
104
|
hello Isha.... its so good to have such a blog which is so useful for people who are interested to learn...... can u please do me a favour.....
ReplyDeletei want the completed SQL SERVER notes could you please help me........ my mail id is " sampathkumar424@yahoo.com " i will waiting for your reply
pls provide solution to all queries to sushubh29@gmail.com
ReplyDeletePlease provide Solution for all queries..
ReplyDeletegud stuff of dis but i dnt know whether its correct r nt could u provide solution 4 all queries plsy id is bharatrocket@gmail.com
ReplyDelete