风趣麦片

文章
3
资源
0
加入时间
3年0月21天

SQL SERVER数据库多条件查询

例如:查询挂号超500的数据select CONVERT(VARCHAR(10),DGH,23),COUNT(*) from yxhis2017..VTBMZGHMX2017 where bth=0 GROUP BY CONVERT(VARCHAR(10),DGH,23) HAVING COUNT(*)>500 ORDER BY CONVERT(VARCHAR(10),DGH,23) ...

READ TABLE - result

READ TABLE - result Syntax ... { INTO wa [transport_options] }   | { ASSIGNING [CASTING] }   | { REFERENCE INTO dref }   | {