Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select CustUserId, COUNT(CustUserId)
- FROM Bookings with (nolock)
- WHERE FirstTimeBooking = 1
- GROUP BY CustUserId
- HAVING COUNT(CustUserId) > 1
- ORDER BY COUNT(CustUserId) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement