title: Count all row in union with pagination (OFFSET,FETCH)
body: <p>Here is my query.</p>
  
  <pre><code> SELECT 
           S.Id,
           S.[Order],
           COUNT(*) OVER () AS Total_Count --Return 4
  FROM Subscriptions S
  UNION 
  SELECT 
           S1.Id,
           S1.[Order],
           COUNT(*) OVER () AS Total_Count --return 5
  FROM Subscriptions1 S1
  ORDER BY [Order] DESC
              OFFSET 0 ROWS 
      FETCH NEXT 2 ROWS ONLY
  </code></pre>
  
  <p>What I want is count 9 (4+5) in every row.</p>