Cacher is the code snippet organizer for pro developers

-- Simple Select
SELECT 'Bananas';

-- Fully Qualified Name (Four Part)
SELECT * FROM Server.Database.Schema.Object;

-- Basic Syntax
SELECT [ All | Distinct ]
     [ TOP (Exp) [Percent] [With Ties]]
   * | {tbl | view | alias}.*  
     | {tbl | view | alias}.column
     | expression  
     [ [ AS ] column_alias ]  
     [ INTO new_source ]
     [ FROM source [, ...n] ]
     [ WHERE condition ]
     [ GROUP BY ]
     [ Having condition ]
     [ Order By exp ]
     [ Option options [,...n] ]

-- Examples >>

-- All
SELECT * FROM Person.Address;

-- Table Aliasing
SELECT addr.* FROM Person.Address addr;

-- Top
SELECT TOP(5) * FROM Sales.Customer;

-- Order By, Desc
SELECT ContactTypeID, Name
    FROM Person.ContactType
    ORDER BY Name DESC;
    
-- Distinct
SELECT DISTINCT Color 
    FROM Production.Product;

-- OVER
SELECT SalesOrderID, ProductID, OrderQty  
    ,SUM(OrderQty) 
        OVER(PARTITION BY 
                    SalesOrderID) AS Total  
    ,AVG(OrderQty) 
        OVER(PARTITION BY 
                    SalesOrderID) AS "Avg"  
    ,COUNT(OrderQty)
        OVER(PARTITION BY 
                    SalesOrderID) AS "Count"  
    ,MIN(OrderQty) 
        OVER(PARTITION BY 
                    SalesOrderID) AS "Min"  
    ,MAX(OrderQty) 
        OVER(PARTITION BY 
                    SalesOrderID) AS "Max"  
FROM Sales.SalesOrderDetail   
WHERE SalesOrderID IN(43659,43664);

-- Having
SELECT SalesOrderID, 
       SUM(LineTotal) AS SubTotal  
FROM Sales.SalesOrderDetail  
GROUP BY SalesOrderID  
HAVING SUM(LineTotal) > 100000.00  
ORDER BY SalesOrderID ;