B
Brave
Unregistered / Unconfirmed
GUEST, unregistred user!
query1.SQL.Clear;
query1.SQL.Add('select *'); // , (价格) as 最底价名称,价格
query1.SQL.Add('from jiage');
query1.SQL.Add('where 价格=');
query1.SQL.Add('(select min(价格) from jiage a');
query1.SQL.Add('where a.name=jiage.name) ');
query1.Open;
query1.SQL.Add('select *'); // , (价格) as 最底价名称,价格
query1.SQL.Add('from jiage');
query1.SQL.Add('where 价格=');
query1.SQL.Add('(select min(价格) from jiage a');
query1.SQL.Add('where a.name=jiage.name) ');
query1.Open;