AND

HAVING

NOT

OR

SELECT DATEDIFF(date('2023-03-13 00:00:00'), date('2023-03-12 18:00:00')) 输出1

以上说法都正确

SELECT DATEDIFF('2023-03-10 09:00:00', '2023-03-12 18:00:00') 输出-2

SELECT timestampdiff(day,'2023-03-14 00:00:00', '2023-03-12 18:00:00') 输出-1

count(distinct column1) > count(1)

count(1) > count(column1)

count(1) > count(distinct column1)

count(1) > count(*)

SELECT * FROM orders o WHERE amount > (SELECT AVG(amount) FROM orders WHERE user_id=o.user_id);

SELECT o.* FROM orders o JOIN (SELECT user_id, AVG(amount) avg_amt FROM orders GROUP BY user_id) t ON o.user_id=t.user_id WHERE o.amount > t.avg_amt;

SELECT o1.* FROM orders o1, orders o2 WHERE o1.user_id=o2.user_id GROUP BY o1.id HAVING o1.amount > AVG(o2.amount);

以上全部

DENSE_RANK() OVER (PARTITION BY employee_id, MONTH(sale_date) ORDER BY sale_amount DESC)

RANK() OVER (PARTITION BY employee_id, MONTH(sale_date) ORDER BY sale_amount DESC)

ROW_NUMBER() OVER (PARTITION BY employee_id, MONTH(sale_date) ORDER BY sale_amount DESC)

DENSE_RANK() OVER (PARTITION BY MONTH(sale_date) ORDER BY sale_amount DESC)

HAVING SUM(金额) > 1000

ORDER BY 总金额 DESC

WHERE 订单日期 >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)

GROUP BY 客户ID