Advertisement
mugs

list orgs with account counts

Aug 23rd, 2015
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.14 KB | None | 0 0
  1. SELECT
  2. ac.ORG_CD,
  3. ac.FIN_COA_CD,
  4. COUNT(*) AS kount
  5. FROM
  6. CA_ACCOUNT_T ac
  7. GROUP BY
  8. ac.ORG_CD,
  9. ac.FIN_COA_CD
  10. ORDER BY
  11. kount DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement