常用取重复记录的SQL语句代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】常用取重复记录的SQL语句

作者:Dezai.CN / 发布于2011/7/26/ 867

<div>
<div id="cnblogs_post_body">
<ol>
    <li>获取某字段或几个字段有重复的数据，可限定重复几条
    select field1,field2 from table group by field1,field2 having count(field1)>1</li>
    <li>获取某字段不重复的最新记录
    select top * from table a where id in(select max(id) from table b group by field) order by id desc</li>
    <li>获取某字段的重复数
    select count(field) from table group by field having count(field)>1</li>
    <li>获取不重复的记录
    select field1,field2 from table group by field1,field2</li>
    <li>删除重复记录
    delete from from table a where id not in(select max(id) from table b group by field)</li>
</ol>
</div>
<script type="text/javascript">
if ($ != jQuery) {
	$ = jQuery.noConflict();
}
var isLogined = false;
var cb_blogId = 47005;
var cb_entryId = 1370922;
var cb_blogApp = "wfwup";
var cb_blogUserGuid = "63fe460b-63cf-dd11-9e4d-001cf0cd104b";
var cb_entryCreatedDate = '2009/1/7 11:18:00';
</script>
</div>

试试其它关键字

　取重复记录　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)