各位
select A.id ||'-'|| A.name
from tableaa A GROUP BY A.id
union all select A.id ||'-'|| A.name from tablebb A GROUP BY A.id
ORDER BY A.id
我这里的order by老有问题,如果把A.id ||'-'|| A.name 改成A.id就没问题了..何解?
如何解决这个问题呢,各位达人
select A.id ||'-'|| A.name
from tableaa A GROUP BY A.id
union all select A.id ||'-'|| A.name from tablebb A GROUP BY A.id
ORDER BY A.id
我这里的order by老有问题,如果把A.id ||'-'|| A.name 改成A.id就没问题了..何解?
如何解决这个问题呢,各位达人
union all select A.id,A.id ||'-'|| A.name as iname from tablebb A GROUP BY A.id)
ORDER BY id多套层试下
from tableaa A GROUP BY A.id这句都会报错你加个GROUP BY干什么呀?
from tableaa A
GROUP BY A.id,A.name
union all
select A.id||'-'||A.name as id from tableaa A
GROUP BY A.id,A.name
ORDER BY id
order by A.id
FROM (
SELECT A.ID || '-' || A.NAME AS ID_NAME,
A.ID AS AID,
ROW_NUMBER() OVER (PARTITION BY A.ID ORDER BY A.ID) AS RNUM
FROM tableaa A UNION ALL SELECT A.ID || '-' || A.NAME AS ID_NAME,A.ID AS AID,
ROW_NUMBER() OVER (PARTITION BY A.ID ORDER BY A.ID) AS RNUM
FROM tablebb A
) B
WHERE B.RNUM = 1
ORDER BY B.AID;没必要用 GROUP BY