主页 / 问题 / 1599762
Accepted
Nigar Hesenli
Asked:2024-11-14 17:12:23 +0800 CST2024-11-14 17:12:23 +0800 CST

合并2个具有相同ID的字符串

  • 772

我有这张表：

订单号 vzato_v_rabotu 扎克里托
abcd 10/01/2024 5:17:15
abcd 01.10.2024 10:05:16

帮我使用 excel 或 sql 将其转换为这种格式：

订单号 vzato_v_rabotu 扎克里托
abcd 10/01/2024 5:17:15 01.10.2024 10:05:16

提前致谢！

mysql

1 个回答

  1. Best Answer

    一切都已经决定了，@Akina，我迟到了:)

    CREATE TABLE orders (
id integer  PRIMARY KEY,
order_id TEXT ,
vzato_v_rabotu  DATETIME,
zakrito DATETIME
);

INSERT INTO orders VALUES (1, 'abcd', '2024-10-01 5:17:15',null);
INSERT INTO orders VALUES (2, 'abcd', null,'2024-10-01 10:05:16');
INSERT INTO orders VALUES (3, 'abcdf', '2024-10-01 9:17:15',null);
INSERT INTO orders VALUES (4, 'abcdf', null,'2024-10-01 12:05:16');


SELECT 
    order_id,
    MIN(vzato_v_rabotu) AS vzato_v_rabotu,
    MAX(zakrito) AS zakrito
FROM 
    orders
GROUP BY 
    order_id;

    +----------+---------------------+---------------------+
| order_id | vzato_v_rabotu      | zakrito             |
+----------+---------------------+---------------------+
| abcd     | 2024-10-01 05:17:15 | 2024-10-01 10:05:16 |
| abcdf    | 2024-10-01 09:17:15 | 2024-10-01 12:05:16 |
+----------+---------------------+---------------------+

    https://onecompiler.com/mysql/42y424juc

    • 2

相关问题