查询的目的,查找倒数10条不重复记录 (表table,字段ID自动编号,字段a为文本),输出a,
怎么写SQL语句

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

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

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;