Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT P.ID, Name, Number, Location, COUNT(year(InterviewDate) AS InterviewNo, Year(InterviewDate) AS Year
- FROM Person AS P INNERJOIN Interview as I ON P.ID = I.ID
- GROUP BY P.ID, Name, Number, Location, Year(InteviewDate)
- HAVING COUNT(Year(InterviewDate)) > 1 AND Year(InterviewDate)='2013'
- SELECT P.ID
- ,Name
- ,Number
- ,Location
- ,InterviewNo
- FROM Person P
- INNER JOIN
- (SELECT ID
- ,COUNT(1) AS InterviewNo
- FROM Interview
- WHERE Year(InterviewDate) = 2013
- GROUP BY ID
- HAVING COUNT(1)> 1) I ON P.ID=I.ID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement