select 字段ID=min(字段ID) ,字段A ,字段B=min(字段B) from tbl group by 字段A
//查詢不重復數據條數 select count(distinct 字段A ) from dbo.Tbl1
死了! Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'count (distinct RemoteIP)' 中为什么我在ASP里这样写不对呢? Select count (distinct RemoteIP) from counter
,字段A
,字段B=min(字段B)
from tbl
group by 字段A
select count(distinct 字段A ) from dbo.Tbl1
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'count (distinct RemoteIP)' 中为什么我在ASP里这样写不对呢?
Select count (distinct RemoteIP) from counter