请问如何将下面这张表里重复id和非重复id记录分成两张表？谢谢

[scorpio2]

请问如何将下面这张表里重复id和非重复id记录分成两张表？谢谢

id test
---------------------------
123 a
133 f
134 d
123 b
153 c
153 a
--------------------------

[scorpio2]

搞定了,VF6的,不能into
先select出来后,再copy to就可以了
谢谢大家啦

[十豆三]

VFP6也是可是INTO的

[wwwwb]

select id into dbf newtt from tt group by id having count(*)>1
select id into dbf newtt1 from tt group by id having count(*)=1

[scorpio2]

我试过了，但报语法错误啦

[wwwwb]

不会吧，我已经测试通过，你的代码？

[scorpio2]

我用的是VFP,不是SQL,这里确实报了错。

[cnszyuxin]

SELECT * FROM abcde WHERE ID In (SELECT ID FROM abcde GROUP BY ID HAVING COUNT(*)=1) Into cursor 没有重复的表
SELECT * FROM abcde WHERE ID NOT In (SELECT ID FROM abcde GROUP BY ID HAVING COUNT(*)=1) Into Cursor 重复ID的表

[wwwwb]

我用的是VFP,不是SQL,这里确实报了错。
我用的是VFP的SQL语句，而且就在VFP中测试通过

[wwwwb]

select id into dbf newtt from tt group by id having count(*)>1
select id into dbf newtt1 from tt group by id having count(*)=1
不知道你是否仔细看看我的代码没有，怎么会是在SQL SERVER中？

[cnszyuxin]

wwwwb()
也许scorpio2 ()的VFP开发版本较低吧.