Advertisement
Guest User

Untitled

a guest
Aug 1st, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.20 KB | None | 0 0
  1. SELECT DISTINCT ObjectId
  2. FROM
  3. (
  4.     SELECT UpdateId
  5.     , ObjectId
  6.     , COUNT(DISTINCT ObjectId) OVER (ORDER BY UpdateId) CNT
  7.     FROM Updates u1
  8.     WHERE UpdateId > @fromUpdateId
  9. ) t
  10. WHERE t.CNT <= 100;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement