BOM数据排序及分级显示
--示例数据:CREATE TABLE t1( Name varchar(20), Col1 varchar(2), Col2 varchar(2), Col3 varchar(2))INSERT t1(Name,Col1,Col2,Col3)SELECT 'A','1','','' UNION ALLSELECT 'A','2','','' UNION ALLSELECT 'A','3','','' UNION ALLSELECT 'A','','4','' UNION ALLSELECT 'A','','5','' UNION ALLSELECT 'A','','6','' UNION ALLSELECT 'A','','7','' UNION ALLSELECT 'A','','','8' UNION ALLSELECT 'A','','','9' UNION ALLSELECT 'A','','','0' UNION ALLSELECT 'B','11','','' UNION ALLS......
阅读全文