如何实现查询前几名?
我想根据从库中调出的数值来确定查询的名次?
var
m,n:integer;
begin
data.ADOQuery.Close;
data.ADOQuery.SQL.Clear;
data.ADOQuery.SQL.Add('select 决赛数额 from begin_sysinfor');
data.ADOQuery.Open;
m:=data.ADOQuery.fieldbyname('决赛数额').AsInteger;
grep_infor.gresultquery.SQL.Add('select top n 单位,项目名称,预赛成绩 from groinfor_input');
grep_infor.gresultQuery.SQL.Add('where 项目名称=:items order by 预赛成绩 asc');
grep_infor.gresultQuery.Parameters.ParamByName('items').Value:=sj;
grep_infor.gresultquery.Parameters.ParamByName('n').Value:=m;
grep_infor.gresultQuery.Open;
错误类型:
not found parameters 'n'