Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Row_number()
- OVER (
- partition BY createddate
- ORDER BY Count(loggedrecid)) AS Col_group,
- Count(loggedrecid),
- createddate,
- ownerteam
- FROM @allrequests
- WHERE faculty IN ( @faculty )
- GROUP BY createddate,
- ownerteam
- ORDER BY createddate ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement