Skip to content

Instantly share code, notes, and snippets.

/gist:3121908

Created July 16, 2012 10:05
Show Gist options
  • Save anonymous/3121908 to your computer and use it in GitHub Desktop.
Save anonymous/3121908 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT s.supplier_number, s.supplier_name, s.`country_of_company` , s.`region` , s.`country_of_company_name` , s.payment_term_key, s.po_spend, s.non_po_spend, s.total_po_spend, s.henkel_entity_name, s.supplier_master_basket_number
FROM `data.real` AS s
GROUP BY s.payment_term_key, s.supplier_name
HAVING COUNT( * ) >=2
ORDER BY `s`.`supplier_number` ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment