oracle 中 minus ，在mssql 中用什么替换？
最新回答
浪漫尽失
2024-01-24 09:22:32
select
name
from
table1
a,table2
b
where
a.name=b.name
再或者把结果集a查出来再在a中按b的条件查：
SELECT
A.*
FROM
#WAN
A,(
SELECT
[NAME]
FROM
(SELECT
*
FROM
#WAN
GROUP
BY
[NAME],[TIME])
T
GROUP
BY
[NAME]
HAVING
COUNT([TIME])=(SELECT
COUNT(*)
FROM
(SELECT
[TIME]
FROM
#WAN
GROUP
BY
[TIME])
[TIME])
)
B
WHERE
A.[NAME]=B.[NAME]
ORDER
BY
A.[TIME],A.[NAME]
热门标签
