sql server 常用查詢

1.查詢表內重複的欄位

select id from table1 where id in(select id from table1 group by id having count(id)>1)

2.select查詢添加自增長的列 作為識別欄位

例子：Select (Select sum(1) from Table1  where ID <= a.ID) as xuhao,* from Table1 a

 

 

SQL 重複資料的提取與過濾

 

提取重複資料

SELECT * FROM tablename GROUP BY colname HAVING COUNT(*) > 1 

 

過濾重複資料

SELECT * FROM tablename GROUP BY colname HAVING COUNT(*) = 1

http://blog.csdn.net/zhoujiaoshou/article/details/7928351

 

============================================

根據日期模糊查詢

Convert(varchar,日期欄位,120) LIKE '%2008-03-22%'