SELECT userno,MAX(username),MAX(cardno),
CONVERT(varchar(10),dealdate,120) 日期,count(*) As nCount
ORDER BY userno,CONVERT(varchar(10),dealdate,120)
CONVERT(varchar(10),dealdate,120) 日期,count(*) As nCount
ORDER BY userno,CONVERT(varchar(10),dealdate,120)
select convert(char(8),getdate(),112) ----20020101
select convert(char(8),getdate(),108) ---06:05:05
CONVERT(varchar(10),dealdate,120) 日期,count(*) As nCount
from 表 group by userno,CONVERT(varchar(10),dealdate,120)
ORDER BY userno,CONVERT(varchar(10),dealdate,120)