select 姓名,月份, 工资
from(
SELECT
distinct 姓名,姓名 as p,1 as o, '' as 月份, '' as 工资
FROM
TA
union all
select '---' as 姓名,姓名,2, ltrim(月份), ltrim(工资) from ta
) a
order by p,o那个a是什么意思啊?我只知道吧表显示车外那个树形结构
from(
SELECT
distinct 姓名,姓名 as p,1 as o, '' as 月份, '' as 工资
FROM
TA
union all
select '---' as 姓名,姓名,2, ltrim(月份), ltrim(工资) from ta
) a
order by p,o那个a是什么意思啊?我只知道吧表显示车外那个树形结构
http://www.dbtuning.cn
主营:中小企业数据库管理、优化、调校服务
========================================