Skip to content

Instantly share code, notes, and snippets.

@radityopw radityopw/cte_c.sql
Last active Feb 29, 2016

Embed
What would you like to do?
use AdventureWorks2012
go
SELECT SalesPersonID, COUNT(*) as JML_ORDER
FROM Sales.SalesOrderHeader
WHERE SalesPersonID IS NOT NULL
GROUP BY SalesPersonID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.