数据库增删改查命令

-- 1、统计行数
SELECT
    count(*) 
FROM
    equipment;
    
-- 2、分组
SELECT
    user_enters_contract,
    count(*) 
FROM
    equipment 
WHERE
    user_enters_contract IS NOT NULL 
GROUP BY
    user_enters_contract 
ORDER BY
    count(*) DESC;

-- 3、并集
SELECT
    item_code 
FROM
    equipment UNION ALL
SELECT
    item_code 
FROM
    sheet1;

-- 4、交集
SELECT
    t1.item_code,
    count(*) 
FROM
    sheet1 t1
    JOIN equipment t2 ON t1.item_code = t2.item_code 
GROUP BY
    t1.item_code 
ORDER BY
    count(*) D