group by + 排序

SELECT distinct fm.N_SEQ_ID, fm.N_GROUP_ID, fm.N_PORT_ID, fm.C_COMPONENT_TYPE, fm.ATTENTION_DATE 
, fm.c_port_name AS productName 
, fm.c_port_code AS fundCode
FROM(SELECT fm1.* FROM new_tfundgroup_member fm1 
INNER JOIN ( 
SELECT DISTINCT (N_SEQ_ID) id 
FROM new_tfundgroup_member WHERE n_group_id IN ('3412225')
ORDER BY ATTENTION_DATE DESC) AS fm2 ON fm2.id = fm1.N_SEQ_ID 
GROUP BY fm1.N_PORT_ID) fm 
WHERE fm.is_effective = 'Y' 
ORDER BY fm.N_SEQ_ID DESC 

SELECT t.N_PORT_ID AS portId, 
IFNULL(t.c_port_name, '--')  AS portName, 
IFNULL(t.c_port_code, '--' ) AS portCode, 
'PORT' AS portType, 
'ZIYOU' AS fundType, 
IFNULL(DATE_FORMAT(t.d_establish,'%Y-%m-%d'), '--') AS establishDate, 
CASE t.c_status WHEN 'W' THEN '已清盘' ELSE '存续' END STATUS,  
IFNULL(DATE_FORMAT(jj.NEW_DATE, '%Y-%m-%d'), '--') AS lastestNavDate, 
'--' AS productOrganization, 
tm.c_fundcom_name AS companyName, 
t.c_invest_strategy AS investStrategy, 
t.c_invest_strategy_child AS investStrategyChild, 
IFNULL(jj.n_zjz, 0)/10000 AS totalAssetValue 
FROM tportbasicinfo t  
LEFT JOIN tcompany tm ON tm.id = t.n_company_id 
LEFT JOIN (SELECT DISTINCT tb1.id,tb1.d_date AS NEW_DATE,tb1.c_fund_code,tb1.n_zjz FROM tb_asset tb1 
INNER JOIN ( 
SELECT DISTINCT id 
FROM tb_asset WHERE c_fund_code IS NOT NULL 
ORDER BY d_date DESC) AS tb2 ON tb2.id = tb1.id 
GROUP BY tb1.c_fund_code  ) jj ON t.c_port_code = jj.c_fund_code 
WHERE t.org_code='ZCTGB' AND t.n_isshow=1 AND t.c_data_source IN ('托管', '外包', '托管+外包', '外包+托管')