[求助] 请大家帮忙写一个查询 - 编程论坛

bjp_zhj2011-08-15 22:38

SELECT DISTINCT TOP 10 [%$##@_Alias].故障记录.报告人
FROM (SELECT 故障记录.报告人, 故障记录.ID FROM 故障记录 WHERE (((故障记录.所属系统)=forms!输入新故障!Combo5) And ((故障记录.部门)=forms!输入新故障!Combo23)) ORDER BY 故障记录.ID DESC) AS [%$##@_Alias];

我写的这个,结果不是按ID倒序的,结果是按故障记录.报告人排序的

wangchatian2011-09-09 22:28

回复楼主 bjp_zhj

var
   s: string;
begin
   s:='select top 10 C_code as ''商品编号'', C_name as ''商品名称'',c_price as ''单价'''+Char(#13)+
      'from T_dia_spxx'+char(#13)+
      'where c_code in ('+char(#13)+
      '                 Select distinct c_code from T_dia_spxx'+char(#13)+
      '                )';
    MessageBox(0, PChar(s), '执行以下SQL查询不重复的前10个商品信息', MB_OK);
    with qry1 do
    begin
         close;
         SQL.Clear;
         sql.Add(s);
         open;
    end;

end;