您所在位置：主题：请求一SQL语句
kerener
[专家分：10] 发布于 2007-05-16 15:07:00
各位好:
我有一个表如下:
RecID,PersonID, Value1, Value2, Notes
1 10 '2007-05-10' '2007-05-15'
2 12 '2007-05-12' '2007-05-16'
3 13 '2007-05-13' '2007-05-14'
求包涵某日期的所有记录;
如:某日期为:'2007-05-11'时满足条件的记录为:1;
a某日期为:'2007-05-14'时,满足条件的记录为:1,2,3;
请各位大侠帮忙!!!
[em1][em1][em1]
我有一个表如下:
RecID,PersonID, Value1, Value2, Notes
1 10 '2007-05-10' '2007-05-15'
2 12 '2007-05-12' '2007-05-16'
3 13 '2007-05-13' '2007-05-14'
求包涵某日期的所有记录;
如:某日期为:'2007-05-11'时满足条件的记录为:1;
a某日期为:'2007-05-14'时,满足条件的记录为:1,2,3;
请各位大侠帮忙!!!
[em1][em1][em1]
