Microsoft SQL Sample Code

The builtin GROUPING_ID function Is a function that computes the level of grouping. GROUPING_ID can be used only in the SELECT list, HAVING, or ORDER BY clauses when GROUP BY is specified. The code below will show you how to use the GROUPING_ID function. For more details on the GROUPING_ID function click here

Select Client_Status, Grouping_ID(Client_Status) AS 'Grouping_ID' From CLIENT Group By Client_Status

If you need any help implementing this sql or modifications made for your needs, please Click Here to get a free quote for your Microsoft SQL Development needs. 

Click Here to learn more about the WSI quoting process.