User Profile

Collapse

Profile Sidebar

Collapse
javindran
javindran
Last Activity: Apr 3 '13, 06:19 AM
Joined: Apr 1 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • javindran
    replied to Help with WHERE clause
    in SQL Server
    still stuck, can u give an example on count
    See more | Go to post

      Leave a comment:

    • javindran
      started a topic Help with WHERE clause
      in SQL Server

      Help with WHERE clause

      Basically, I need to find the department which consists more than 10 staffs as I am stuck.

      Code:
      SELECT dname, sid
FROM dept INNER JOIN staff ON dept.did = staff.did
WHERE ?????? (this is the part where I am stuck)
      Any SQL will be helpful.
      I will frequently monitor this question to reply to ur answers and questions if u need it.
      Thanks in advance.
      See more | Go to post
      Last edited by Niheel; Apr 2 '13, 07:20 PM. Reason: Please use code tags when posting code.
      No activity results to display
      Show More
      Working...