![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
小七de尾巴
这个作者很懒,什么都没留下…
展开
-
PostgreSQL SUM踩坑
空集合的SUM()将返回NULL,而不是零。原创 2024-05-06 21:44:16 · 502 阅读 · 1 评论 -
常见数据库删除重复数据中一条数据SQL
AccessDELETE FROM (SELECT TOP 1 * FROM tbName WHERE condWhere)MysqlDELETE FROM tbName WHERE condWhere LIMIT 1SqlServerDELETE TOP 1 FROM tbName WHERE condWhereOracleDELETE FROM tbName WHERE ROWID IN ( SELECT ROWID FROM tbName WHERE condWhere AND R原创 2020-11-18 16:20:36 · 241 阅读 · 0 评论