SQL Server
sail_zhang
这个作者很懒,什么都没留下…
展开
-
查询某列重复的记录
<br />select apsh.apsh_team_group_id from active_photos_site_hierarchy apsh<br />where apsh.apsh_team_group_id in (<br /> select apsh1.apsh_team_group_id from active_photos_site_hierarchy apsh1<br /> group by apsh1.apsh_team_group_id<br /> having count(a原创 2010-06-03 16:59:00 · 277 阅读 · 0 评论 -
把一张表数据导入到另外一张表
<br />select * into some_table_bak from some_table (nolock)<br />不用手动建some_table_bak表,会自动创建。原创 2010-06-10 10:51:00 · 674 阅读 · 1 评论