SQL 查询不重复
我有一张Product表,ID设为主键,ID,Title,Text1,class,SHIJIAN我用DropDownList1绑定后会出现重复的值,我绑定的字段是SHIJIAN,怎么把重复的值筛选出来, --------------------编程问答-------------------- 用distinct()过滤重复的值--------------------编程问答--------------------
SELECT DISTINCT SHIJIAN FROM Product--------------------编程问答-------------------- 在sqlserver中写sql语句返回个不重复的结果集 --------------------编程问答-------------------- select * from Product where SHIJIAN in(select SHIJIAN from Product group by SHIJIAN having COUNT(SHIJIAN)>1) --------------------编程问答--------------------
SELECT DISTINCT SHIJIAN FROM Product
补充:.NET技术 , C#