这要看你使用的sql语句了:ADOQuery.Sql.Add('select top 10 * from goods');
order by ... 你的排序规则
我写的是 with Query1 do begin close; sql.clear; sql.add('select goods.goods_name,record.sell_num from goods,record'); sql.add('where goods.goods_id=record.goods_id'); sql.add('order by record.sell_num DESC'); open; end; 该怎么改
sql.add('select top 10 goods.goods_name,record.sell_num from goods,record'); sql.add('where goods.goods_id=record.goods_id'); sql.add('order by record.sell_num DESC');
with Query1 do
begin
close;
sql.clear;
sql.add('select goods.goods_name,record.sell_num from goods,record');
sql.add('where goods.goods_id=record.goods_id');
sql.add('order by record.sell_num DESC');
open;
end;
该怎么改
sql.add('where goods.goods_id=record.goods_id');
sql.add('order by record.sell_num DESC');