按日期分组 查询问题~ 100分！

[popid]

sql 语句如下：
select logindate,username
from user
where logindate betwee @startdate and @enddate
(group by logindate)???问题
我想让logindate 按天分组，@startdate可能是07年的一天和@enddate是08年的一天，跨年如何解决分组啊？

[生活真美好]

convert()按121转换为10位字符即可

[中国风]

select logindate=convert(varchar(10),logindate,120),username
from [user]
where logindate betwee @startdate and @enddate
group by convert(varchar(10),logindate,120),username

[子陌红尘]

??

select 
    convert(char(10),logindate,120),username 
from 
    user 
where  
    logindate  betwee @startdate  and  @enddate 
group by
    convert(char(10),logindate,120) 

[dawugui]

[Quote=引用楼主 popid 的帖子:]
sql 语句如下：
select logindate,username
from user
where logindate betwee @startdate and @enddate
(group by logindate)???问题
我想让logindate 按天分组，@startdate可能是07年的一天和@enddate是08年的一天，跨年如何解决分组啊？
[/Quote]

select convert(varchar(10) ,logindate , 120) riqi,max(username)
from user 
where  logindate  betwee @startdate  and  @enddate 
group by convert(varchar(10) ,logindate , 120)

select convert(varchar(10) ,logindate , 120) riqi,min(username)
from user 
where  logindate  betwee @startdate  and  @enddate 
group by convert(varchar(10) ,logindate , 120)

[水族杰纶]

select DATEPART(DD,logindate),username 
  from [user] 
  where  logindate  betweeN @startdate  and  @enddate 
  group by  DATEPART(DD,logindate),username 

[bennyyyyy]

用convert

[nalnait]

group by convert(varchar(10),logindate,120)

[bhtfg538]

select 
    convert(char(10),logindate,120),username 
from 
    user 
where  
    logindate  betwee @startdate  and  @enddate 
group by
    convert(char(10),logindate,120) 

--使用 CTE
WITH FUCK AS
(
select 
    convert(char(10),logindate,120) as something,username 
from 
    user 
where  
    logindate  betwee @startdate  and  @enddate 

)
select * from FUCK group by something

[dobear_0922]

如果2007-12-22与2008-12-22分在同一组：

select right(convert(varchar(10) ,logindate , 120),5) riqi,min(username)
from user 
where  logindate  betwee @startdate  and  @enddate 
group by right(convert(varchar(10) ,logindate , 120),5)

[tmd456]

select
convert(char(10),logindate,120),username
from
user
where
logindate betwee @startdate and @enddate
group by
datename(dd, logindate)

[ou_yangpengfei]

路过

[wanshichen]

group by convert(varchar(10),logindate,120)

[yesterday1013]

恩~真的很好啊！

[richnaly]

[Quote=引用 4 楼 dawugui 的回复:]
引用楼主 popid 的帖子:
sql 语句如下：
select logindate,username
from user
where logindate betwee @startdate and @enddate
(group by logindate)???问题
我想让logindate 按天分组，@startdate可能是07年的一天和@enddate是08年的一天，跨年如何解决分组啊？



SQL codeselect convert(varchar(10) ,logindate , 120) riqi,max(username)
from user
where logindate betwee @startdat…
[/Quote]
支持

[super_iven]

UP

[lzd1_83]

select 
    convert(char(10),logindate,120),username 
from 
    user 
where  
    logindate  between @startdate  and  @enddate 
group by
    convert(char(10),logindate,120) 

[bluefangxiao]

select 
    convert(char(10),logindate,120),username 
from 
    user 
where  
    logindate  betwee @startdate  and  @enddate 
group by
    convert(char(10),logindate,120) 

[chaofeipz]

mysql 是这样写的
select
DATE(logindate),username
from
user
where
logindate betwee begindate and enddate
group by
DATE(logindate)