plz help me out in writing a small query

• Chinna

  SSCertifiable

  Points: 5408

  More actions

  February 1, 2008 at 9:05 am

  #186179

  DepartmentIDDepartmentName

  1Human Resources

  2Information Technology

  3Marketing

  4Legal

  Table: Department

  Table: Employee

  EmployeeIDEmployeeNameDepartmentID

  1 Paul3

  2 John1

  3 Mary4

  4 JosephNull

  5 Leo1

  6 Mark3

  7 Scott3

  6.List all the departments that don’t have any employees. (Without using sub query)

  7.List the departments with the number of employees.

  9.How will you check the locks on a table?

  Thanks,
  Chinna

  Its the Journey which gives you Happiness not the Destination-- Dan Millman

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  February 1, 2008 at 9:22 am

  #774282

  Posting homework is bad enough. Cross-posting homework is getting a bit over the line. See my response on the other thread.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  February 1, 2008 at 9:42 am

  #774308

  Y, seriously dude... we can't do your homework for you.

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE:
  
  

• Bob Griffin

  SSCertifiable

  Points: 5982

  More actions

  February 1, 2008 at 9:50 am

  #774314

  use your text book and skat...