Sql查询除ID以外相同的数据
摘要：
id NAME AGE1 n1 12 n1 13 n2 24 n2 25 n22 26 n2 37 n111 18 n222 29 n333 3 查询结果ID NAME AGE1 n1 12 n1 13 n2 24 n2 2----WITH T1 AS (SELECT NAME,AGE FROM FABU GROUP BY NAME,AGE HAVING COUNT(*) >= 2)SELECT ID,NAME,AGE FROM FABU WHERE NAME IN (SELECT NAME FROM T1) AND AGE IN (SELECT AGE FROM T1) 阅读全文
posted @ 2013-07-03 16:32 水行者 阅读(438) 评论(0) 推荐(0) 编辑
