导航

得到相同的数据

Posted on 2012-05-04 15:01  雨-夜  阅读(135)  评论(0编辑  收藏  举报

FROM         t_customer
WHERE     (Customer_number IN
                          (SELECT     Customer_number
                            FROM          t_customer AS companyepe_2
                            GROUP BY Customer_number
                            HAVING      (COUNT(Customer_number) > 1)))