declare @start datetime; set @start='2013/8/5'; select * from data_XiBaoZLSQB where datediff(d,@start,RiQi)>=0

SELECT * FROM table1;SELECT * FROM table2;SELECT * FROM table3;

方法一：Distinct SELECT DISTINCT ColName FROM TableName方法二：Group By SELECT ColName FROM TableName GROUP BY ColName 更多内容： 查询并统计该字段的数量 SELECT ColName,COUNT(COlName) FROM TableName GROUP B

SELECT COUNT(*) FROM TableName

declare @start datetime; set @start = '2013/07/01'; SELECT a.XingMing,b.YiYuanMC,a.RiQi FROM data_XiBaoZLSQB as a LEFT JOIN BaseInfo_YiYuanXXB as b ON a.YiYuanMC_id=b.YiYuanBH WHERE datediff(d,@start,