SQL
xck01
知道改变命运,梦想成就未来!
展开
-
查询SQL表中某几个字段值有重复的记录
SELECT *FROM BXSK_Tab3WHERE (skid IN (SELECT skid FROM BXSK_Tab3 WHERE (upYear = 2008) AND (upMonth = 4) GROUP BY skid HAVING (COUNT(skid) > 1)) andupyear IN原创 2008-05-05 16:51:00 · 3523 阅读 · 1 评论 -
关联更新
UPDATE table1SET city_id = table2.idFROM table1, table2WHERE table1.city = Table2.city原创 2008-05-09 14:52:00 · 488 阅读 · 0 评论