DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

SELECT MAX AS N'NHÓM CẤP 1', MAX AS N'MÃ NHÓM VẬT LIỆU', MAX AS N'TÊN NHÓM VẬT LIỆU',
MAX AS N'MÃ NHÓM CHA', MAX AS N' NHÓM VẬT LIỆU CHA',MAX AS N'ĐƠN VỊ TÍNH', MAX AS IS_LEAF,
MAX AS LEVEL, MAX AS EXP_ACCTNO,
MAX AS INC_ACCTNO, MAX AS LIQ_ACCTNO, MAX AS MATERIAL_ACCTNO,
MAX AS MATERIAL_ACCTNO_NHNN, MAX AS VAT_ACCTNO, MAX AS N'GHI CHÚ'
FROM MW_GROUP A
LEFT JOIN MW_GROUP B ON A.PARENT_ID = B.GROUP_ID
GROUP BY A.GROUP_CODE
HAVING COUNT (*) =1
ORDER BY MAX DESC, MAX