SQL学习路线

 

SQL示例

SELECT 
    Product_Name AS Name,           -- ALIAS
    SUM(Amount) AS Total_Sales      -- FUNCTIONS (SUM)
FROM Sales
WHERE Region IN ('North', 'East')   -- WHERE & IN
GROUP BY Product_Name               -- GROUP BY
HAVING SUM(Amount) > 1000           -- HAVING
ORDER BY Total_Sales DESC;          -- ORDER BY & DESC

SQL Concepts

1. ALIAS

• AS

2. GROUP BY

• COLUMN
  • HAVING

3. WHERE

• LIKE
• IN
• BETWEEN
• ANY
• EXIST
• AND OR NOT

4. FUNCTIONS

• AVG( )
• SUM( )
• COUNT( )
• MIN( )
• MAX( )

5. JOINS

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN

6. ORDER BY

• ASC
• DESC