mysql - 复杂的sql查询转换为rails Controller

Question

我有这个sql查询，需要将其更改为rails Controller

SELECT * FROM ( SELECT vendorName,startTime,endTime,appsImported,result,logfile 
             FROM appmall_dev.data_imports d order by startTime desc)as t 
             group by t.vendorNAme;

Answer 1

DataImport.select("vendorName,startTime,endTime,appsImported,
                   result,logfile").group("vendorName").order("startTime desc")