select company from jfqk where reday=(select max(reday) from jfqk ) and lib='总部'and nopay<>0
select top 1 company from jfqk where lib='总部'and nopay<>0 order by reday desc
SELECT TOP 1 * FROM jfqk WHERE lib='总部'and nopay<>0 ORDER BY Reday DESC
如果lib 不等于总部,而是等于了个参数怎么改?
'select company from jfqk where reday=(select max(reday) from jfqk ) and nopay<>0 and lib='''+(参数)+'''' 极限和深思的sql语句效率更高一些,该法类似
adoquery1.add('SELECT TOP 1 * FROM jfqk WHERE lib=:lib and nopay<>0 ORDER BY Reday DESC'); adoquery1.parameters.parambyname('lib').Value:=trim(editt1.text); adoquery1.open;
查找条件是reday=max(reday) and lib='总部'and nopay<>0 能确定是一条记录吗??? top 1 ???
where lib='总部'and nopay<>0
order by reday desc
ORDER BY Reday DESC
and lib='''+(参数)+''''
极限和深思的sql语句效率更高一些,该法类似
ORDER BY Reday DESC');
adoquery1.parameters.parambyname('lib').Value:=trim(editt1.text);
adoquery1.open;
能确定是一条记录吗???
top 1 ???