query.close; query.sql.clear; query.sql.add('select * from TblUser where Branch=:Branch'; query.sql.paramster[0].value:=YOUR_VALUE; query.open; query.first; while not query.eof do begin combobox1.items.add(query.fields[0].astring); query.next; end;
select Name from TblUser where Branch in (select Branch from TblUser group by Branch having count(*)>1)
实在有点不明白!
query.sql.clear;
query.sql.add('select * from TblUser where Branch=:Branch';
query.sql.paramster[0].value:=YOUR_VALUE;
query.open;
query.first;
while not query.eof do
begin
combobox1.items.add(query.fields[0].astring);
query.next;
end;
where Branch in (select Branch from TblUser group by Branch having count(*)>1)