这样的SQL语句怎么写？？

[fdlqcc]

数据库中有表table1
startdate enddate num
2003-07-29 2003-08-10 200.0
2003-08-11 2003-08-20 100.0
2003-08-21 2003-08-28 150.0
2003-07-21 2003-07-28 130.0
求一SQL语句可得到2003-7-29(startdate)到2003-8-28(enddate)的num之和,谢谢大家

[txlicenhe]

Select sum(num) from table1
where startdate >= '2003-7-29' and enddate <= '2003-8-28'

[pengdali]

Select sum(num) 和 from 表 where startdate>='2003-7-29' and enddate<= '2003-8-28'

[z5wjz]

Select sum(num) from table1 where startdate >= '2003-7-29' and enddate <= '2003-8-28'

[hjb111]

select sum(num) from yourtable where startdate>'2003-7-29' and enddate<='2003-8-28'