odbtools/odbctest/mql/uino/301.groupby查询.mql

-- select attr9 from /mingdao1/staff group by attr9

-- /**
-- output()
-- **/
-- ;


-- SELECT 
--       contract.attr15
--     FROM /mingdao1/contract contract 
--     WHERE 
--       attr3 = '金融' 
--     LIMIT 0, 20000
-- /**
-- output()
-- **/
-- ;

SELECT
sum(contract.attr15) AS "总金额"
FROM /mingdao1/contract contract
WHERE
attr3 = '金融'
LIMIT 0, 20000
/**
output()
**/
;