求订单统计SQL语句
订单数据表结构[user] [mobile]
zhangsan 13900000000
lisi 13900000000
wangwu 13888888888
想得到结果
zhangsan 13900000000
lisi 13900000000
即,用户名不一样,而手机号一样的顾客列表。 --------------------编程问答-------------------- 你应该发到数据库栏 --------------------编程问答-------------------- select * from Users
where [mobile] in
(select [mobile] from Users group by [mobile] having(count(*))>1 )
--你没说表名,我直接用Users做表名了 --------------------编程问答--------------------
select * from Table) --------------------编程问答-------------------- select u1.* from TbUser u1,User u2 where u1.user!=u2.user and u1.mobile=u2.mobile --------------------编程问答-------------------- +1
where [mobile] in
(select DISTINCT [mobile] from Table
补充:.NET技术 , C#