Advertisement
Guest User

Untitled

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