![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
rocksword
这个作者很懒,什么都没留下…
展开
-
Finding Duplicate Records Using GROUP BY in SQL Server
There are various times when we need to find duplicate records in SQL Server. It is possible to find duplicates using DISTINCT, ROW NUMBER as well as the GROUP BY approach.Duplicate records ca转载 2015-06-29 19:03:37 · 269 阅读 · 0 评论 -
SELECT AS in WHERE
First, you cannot use ALIAS on the WHERE clause. You should be using the column,SELECT SUBSTRING(rating, INSTR(rating,',') +1, +2) AS val FROM users WHERE SUBSTRING(rating, INSTR(rating,','转载 2015-06-30 11:58:30 · 349 阅读 · 0 评论