SQL获取前五的产品

获取前五的产品

private void getTop5ForProduct(GylOriginalTransactionDataVo entity) {
    List<Object> list = new ArrayList<>();
    List<Map<String, Object>> lists = gylOriginalTransactionDataMapper.getTopPriceForProduct(entity);
    if (!lists.isEmpty()) {
        for (Map<String, Object> map : lists) {
            for (String s : map.keySet()) {
                if (s.equals("productname")) {
                    list.add(map.get(s));
                }
            }
        }
    }
    List<String> strs = (List<String>) (List) list;
    entity.setProductList(strs);
}

xml

SELECT TOP 5 productname AS productname, SUM ( CAST ( ( CASE WHEN totalpurprice IS NULL OR totalpurprice = '' THEN '0' ELSE totalpurprice END ) AS DECIMAL ( 18, 2 ) ) ) AS totalpurprice FROM gyl_original_transaction_data province=#{province} hospitalname=#{hospitalname} platformusername=#{platformusername} GROUP BY productname ORDER BY totalpurprice DESC