在Delphi的SQL Explore环境中运行如下(数据源为Access):
select failitem,count(failitem) as qty from tmpfail group by failitem
显示如下:
FailItem QtyB001 1
DS01 2
DF03 1
FD02 3本人想按Qty的大小排序,但在上语句中加 order by qty,即运行:
select failitem,count(failitem) as qty from tmpfail group by failitem order by qty,则提示:
“ General SQL Error[Microsoft][ODBC Microsoft Access Driver]参数不足,期待是1”。
请高手赐教!!急等!!!
select failitem,count(failitem) as qty from tmpfail group by failitem
显示如下:
FailItem QtyB001 1
DS01 2
DF03 1
FD02 3本人想按Qty的大小排序,但在上语句中加 order by qty,即运行:
select failitem,count(failitem) as qty from tmpfail group by failitem order by qty,则提示:
“ General SQL Error[Microsoft][ODBC Microsoft Access Driver]参数不足,期待是1”。
请高手赐教!!急等!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货