select fields(你的字段) from tablename(表名) groups by fields(你的字段) having count(*)>1//==============为什么我的要报错呢select 表号 from db groups by 表号 having count(*)>1
select age,count(ag) from table group by age having count(ag)>1
select 表号 from db group by 表号 having count(*)>1后--------------------------- Debugger Exception Notification --------------------------- Project Project1.exe raised exception class EDatabaseError with message 'ADOQuery1: Missing SQL property'. Process stopped. Use Step or Run to continue. --------------------------- OK Help --------------------------- 为什么呀。急呀
uniqueform.ADOQuery1.Active:= true; uniqueform.ADOQuery1.SQL.Clear; uniqueform.ADOQuery1.SQL.Text:= 'select 表号 from db group by 表号 having count(*)>1'; uniqueform.ADOQuery1.ExecSQL;
select fields(你的字段) from tablename(表名) groups
by fields(你的字段) having count(*)>1
select fields(你的字段) from tablename(表名) groups
by fields(你的字段) having count(*)>1//==============为什么我的要报错呢select 表号 from db groups by 表号 having count(*)>1
Debugger Exception Notification
---------------------------
Project Project1.exe raised exception class EDatabaseError with message 'ADOQuery1: Missing SQL property'. Process stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------
为什么呀。急呀
uniqueform.ADOQuery1.SQL.Clear;
uniqueform.ADOQuery1.SQL.Text:= 'select 表号 from db group by 表号 having count(*)>1';
uniqueform.ADOQuery1.ExecSQL;