从表中删除重复的行 [英] Removing duplicate rows from a table
本文介绍了从表中删除重复的行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
id lat long speed date address
1 22.92138131 72.44103313 3.96 km/h 2011-09-26 National, Gujarat, India
2 22.92138145 72.44103413 13.96 km/h 2011-09-26 National, Gujarat, India
3 22.92138134 72.44103423 15.96 km/h 2011-09-26 National, Gujarat, India
4 22.92138454 72.44103233 13.96 km/h 2011-09-26 10t ring Rd, Nehru Nagar
5 22.92138354 72.44102533 13.96 km/h 2011-09-26 Anandnagar Rd, Ahmedabad
6 22.92138484 72.44103293 19.96 km/h 2011-09-26 Anandnagar Rd, Ahmedabad
我想编写一个查询,使我的结果看起来像这样:
I want to write a query such that my result looks like this:
id lat long speed date address
1 22.92138131 72.44103313 3.96 km/h 2011-09-26 National, Gujarat, India
4 22.92138454 72.44103233 13.96 km/h 2011-09-26 10t ring Rd, Nehru Nagar
5 22.92138354 72.44102533 13.96 km/h 2011-09-26 Anandnagar Rd, Ahmedabad
我想根据地址删除重复的行.
I want to remove duplicate rows according to the address.
推荐答案
假定您希望返回ID值最小的行:
Assuming that you wish to return the rows with the smallest ID values:
SELECT
*
FROM
TABLENAME T INNER JOIN
(
SELECT MIN(ID) AS ID FROM TableName
GROUP BY Address
) SUB ON T.ID = SUB.ID
这篇关于从表中删除重复的行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文