MySql常见技术总结

最新推荐文章于 2024-11-15 14:18:15 发布

汪小白JIY

最新推荐文章于 2024-11-15 14:18:15 发布

阅读量132

点赞数 3

分类专栏：数据库(MySql\SqlServer\Oracle) 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_37997978/article/details/138805120

版权

数据库(MySql\SqlServer\Oracle) 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

1、删除数据表某一列重复行

delete from events_copy1 where id in(
select id FROM (  
    SELECT *,  ROW_NUMBER() OVER (PARTITION BY srcIndex ORDER BY srcIndex) AS rn  
    FROM `events_copy1` where `happenTime` >= '2024-05-11 00:00:00' AND `happenTime` <= '2024-05-11 23:59:59'  
) t1 WHERE t1.rn > 1);

select count(distinct srcIndex) from events where `happenTime` >= '2024-05-11 00:00:00' AND `happenTime` <= '2024-05-11 23:59:59';