引用 2 楼 yinan9 的回复:SQL code?1234select plateno from tbl a where (select count(1) from (select distinct lon, lat from tbl where plateno = a.plateno)) = 1; 这样有问题 比如第一条和最后一条一样,就查不……
SQL code?1234select plateno from tbl a where (select count(1) from (select distinct lon, lat from tbl where plateno = a.plateno)) = 1;
引用 3 楼 netajax1 的回复:引用 2 楼 yinan9 的回复:SQL code?1234select plateno from tbl a where (select count(1) from (select distinct lon, lat from tbl where plateno = a.plateno)) = 1;不是>1 ……
引用 2 楼 yinan9 的回复:SQL code?1234select plateno from tbl a where (select count(1) from (select distinct lon, lat from tbl where plateno = a.plateno)) = 1;不是>1 ?
select plateno from tbl a where (select count(1) from (select distinct lon, lat from tbl where plateno = a.plateno)) = 1;
17,377
社区成员
95,128
社区内容
加载中
试试用AI创作助手写篇文章吧