数据提取问题~~~！求助了
NUM AREA TIME1 TIME2INT TEXT DATETIME DATETIME
要统计TIME2--TIME1=0的NUM的个数显示在下表里``SQL语句该怎么写
NUM AREA COUNT（NUM）
2004-12-29 14:32
2004-12-29 14:47
2004-12-29 15:13
2004-12-29 15:17
2004-12-29 16:11
2004-12-29 16:12
2004-12-29 16:27
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>无标题文档</title> </head>
<body> <% Set cn=Server.CreateObject("ADODB.Connection") cn.ConnectionString="DSN=weisheng;UID=sa;PWD=transit" cn.open Set rs=Server.CreateObject("ADODB.Recordset") Source="select Num,Area,num_count=count(num) from card1 GROUP BY Num" rs.Open source,cn Response.Write"<TABLE BORDER ALIGN=CENTER>" Response.Write"<TR>" Response.Write"<TD>地区编码</TD>" Response.Write"<TD>地区名称</TD>" Response.Write"<TD>卡片数目</TD>" DO While Not rs.Eof Response.Write"<TR>" For I=o to rs.Fields.Count-1 Response.Write"<TD>"&rs(I).Value&"</TD>" NEXT rs.MoveNext LOOP rs.Close cn.Close Set rs=Nothing Set cn=Nothing %> </body> </html>
2004-12-29 16:39
2004-12-29 16:40
[Microsoft][ODBC SQL Server Driver][SQL Server]不能比较或排序 text、ntext 和 image 数据类型，除非使用 IS NULL 或 LIKE 运算符。
/2/tongji.asp，行15
2004-12-30 08:41