Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT [Date],[Domain]
- FROM (
- SELECT [Date] ,[Domain],
- ROW_NUMBER() OVER (PARTITION BY [Domain] ORDER BY [Date]) AS recID
- FROM Delivery ) AS r
- ORDER BY recID, (CASE WHEN domain >1 THEN domain ELSE
- domain+(select top 1 domain from delivery order by domain desc) END)
Advertisement
Add Comment
Please, Sign In to add comment