SHARE
TWEET

Untitled

a guest Jun 26th, 2019 49 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2. [Master_ID]
  3. ,COUNT(DISTINCT [parent_file_id]) AS Number_of_parent_files
  4. ,COUNT([Child_ID]) AS Number_of_child_files
  5. FROM [EXAMPLE_TABLE]
  6. GROUP BY [Master_ID]
  7. ORDER BY 1
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top