04 2019 档案
摘要:例如:查询挂号超500的数据select CONVERT(VARCHAR(10),DGH,23),COUNT(*) from yxhis2017..VTBMZGHMX2017 where bth=0 GROUP BY CONVERT(VARCHAR(10),DGH,23) HAVING COUNT(
阅读全文
摘要:举例如下: SELECT ROW_NUMBER()OVER(ORDER BY (SELECT 0)) AS ROWNUM,* FROM YXHIS2018..TBMZGHMX201801 --不排序SELECT ROW_NUMBER()OVER(ORDER BY DCSNY DESC) AS ROW
阅读全文
摘要:以下SQL基本语法皆由本人整理,以下做一个汇总,关于游标,可作为了解,不要求掌握,其他查询、修改、删除操作等基本语法必须会使用。select * from [dbo].[TBICJE]select myktsqye+myktczze+mykttfze-myktxfze-myktye-mhkje+my
阅读全文
摘要:使用DATEDIFF(取值,时间字段1,时间字段2) 举例: SELECT DATEDIFF(YEAR,DRYSJ,DCYSJ),* FROM YXHIS2019..TBZYBR2019 --SQL SERVER 取另两个时间字段之间的间隔时间,年 SELECT DATEDIFF(MONTH,DRY
阅读全文