SQL 代码：
WITH RankedOrders AS (
SELECT *,
ROW_NUMBER() OVER (
PARTITION BY customer_id, product
ORDER BY id ASC
) as rn
FROM orders
)
DELETE FROM orders
WHERE id IN (
SELECT id FROM RankedOrders
WHERE rn > 1
);
订阅：
博文评论 (Atom)
SQL窗口函数面试题与解答2
查找每个部门薪资排名前两名的员工 SELECT * FROM ( SELECT 'OrangeDBM' as AUTHOR,department, name, salary, DENSE_RANK() OVER (PARTITION BY departme...
-
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for employees -- -----------------------...
-
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for employees -- ------------------------...
-
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for customers -- -------------------------...
没有评论:
发表评论