sql简单查询问题。。

[fwqkey]

表tb
有如下字段：
id，ming（名称），lianjie(网址),adress,lianxiren,fuzheren,youbian,e-mail,chuanzhen,time,dizi

请写一个SQL查询time在2009-4-1号到2009-4-30号之间的数据并且通过dizi分组（把每个组的数据找出来）
谢谢

[让你望见影子的墙]

select * from time between '2009-4-1' and '2009-4-30' order by dizi

[liangCK]

SELECT dizi
FROM tb
WHERE time BETWEEN '2009-4-1' AND '2009-4-30'
GROUP BY dizi

[让你望见影子的墙]

[Quote=引用 1 楼 HEROWANG 的回复:]
select * from tb where time between '2009-4-1' and '2009-4-30' order by dizi
[/Quote]
少打几个字

[-狙击手-]

where [time] between '2009-4-1' and '2009-4-30 23:59:59'
group by dizi

[百年树人]

select * from tb where [time]>'2009-04-01' and [time]<'2009-4-31'

通过dizi分组? 楼主要的结果格式是怎么样的？

[fwqkey]

[Quote=引用 5 楼 josy 的回复:]
SQL codeselect * from tb where [time]>'2009-04-01' and [time]<'2009-4-31'



通过dizi分组? 楼主要的结果格式是怎么样的？

[/Quote]显示所有数据呀。

[qizhengsheng]

select max(id),max(ming)...dizi from ta where time bewteen '2009-4-1' and 2009-4-30 group by dizi

[fwqkey]

[Quote=引用 2 楼 liangCK 的回复:]
SQL codeSELECT dizi
FROM tb
WHERE time BETWEEN '2009-4-1' AND '2009-4-30'
GROUP BY dizi
[/Quote]这样就只查询出地址了？

[conan304]

select *
from tb
where [time] between '2009-4-1' and '2009-4-30 23:59:59'
group by dizi

[qizhengsheng]

select max(id),max(ming)...dizi from ta where time bewteen '2009-4-1' and '2009-4-30' group by dizi

[qizhengsheng]

between ,打错了

[fwqkey]

[Quote=引用 9 楼 conan304 的回复:]
SQL codeselect *
from tb
where [time] between '2009-4-1' and '2009-4-30 23:59:59'
group by dizi
[/Quote]晕。有你这么写的吗。。。

[fwqkey]

[Quote=引用 10 楼 qizhengsheng 的回复:]
SQL codeselect max(id),max(ming)...dizi from ta where time bewteen '2009-4-1' and '2009-4-30' group by dizi
[/Quote]为什么用max????