Saturday 13 April 2013

SQL Server Queries for Practice


Written By:- Isha Malhotra
Our Website:-Tech Altum

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


4 comments:

  1. 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.....
    i want the completed SQL SERVER notes could you please help me........ my mail id is " sampathkumar424@yahoo.com " i will waiting for your reply

    ReplyDelete
  2. pls provide solution to all queries to sushubh29@gmail.com

    ReplyDelete
  3. Please provide Solution for all queries..

    ReplyDelete
  4. gud 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