sql语句查询不重复数据

@党贫5310：sql 查询不重复记录 -
沙武18475414734…… SQL查询不重复记录,操作如下:1、假如要查询t1表中name字段中所有的姓名,并去除重复.2、可以使用如下语句:SELECT DISTINCT name FROM t1;3、其中DISTINCT是去重功能.

@党贫5310：sql语句查数据库中不重复的信息 -
沙武18475414734…… select distinct name from tableName;

@党贫5310：sql查询两表中不重复记录 -
沙武18475414734…… select * from table1 where not exists (select 1 from table2 where 关键字=table1.关键字);

@党贫5310：sql查询中,如何查询(筛选)某字段中不重复的条目! -
沙武18475414734…… select distinct 字段名 from 表名 或 select 字段名 from 表名 group by 字段名

@党贫5310：sql语句如何查询不重复记录 -
沙武18475414734…… select distinct [name] from (select * from [table] order by scroe) as T

@党贫5310：sql查询不重复记录 -
沙武18475414734…… distinctsql = ＂select name1,num9,money9,posttime1,distinct(dh1) as DH1 from sp_shop0 ＂

@党贫5310：SQL 查询表中某一字段不重复的所有数据 -
沙武18475414734…… SELECT * FROM tablea WHERE (number NOT IN (SELECT ta.number FROM tablea AS ta INNER JOINtablea AS tb ON ta.number = tb.number AND ta.id tb.id))

@党贫5310：sql 查询数据表后 在统计某一列数据不重复的数量 -
沙武18475414734…… select count(distinct 字段名) from 表名

@党贫5310：sql 查询不重复的记录 -
沙武18475414734…… select uid, max(convert(varchar(10),time,120)) as time from table where time>'2009-11-29' and time

@党贫5310：问个简单的sql查询,怎么查数据库中不重复的列值 -
沙武18475414734…… 如果得到所有值不重复. select cc from tablename group by cc 或 select distinct cc form tablename 如果得到没有重复的所有制, select cc from tablename group by cc minus select cc from( select cc,count(*) from tablename group by cc having count(*)>1) A