怎么将查询结果合并

如何将查询结果合并
有两条sql语句
select top 3 NOTICENO,NT_TITLE,NT_CONTENT,USERNAME,ADDTTIME
from NOTICES where DISPLAY=1

select top 3 NOTICENO,NT_TITLE,NT_CONTENT,USERNAME,ADDTTIME
from NOTICES

如何将这两条语句查询结果合并（相同的就合并）

[解决办法]

SQL code

select top 3 NOTICENO,NT_TITLE,NT_CONTENT,USERNAME,ADDTTIMEfrom NOTICES where DISPLAY=1union  --去掉两个查询的重复行，重复行显示一次select top 3 NOTICENO,NT_TITLE,NT_CONTENT,USERNAME,ADDTTIMEfrom NOTICES
[解决办法]
SQL code
select top 3 NOTICENO,NT_TITLE,NT_CONTENT,USERNAME,ADDTTIMEfrom NOTICES;with tmp as (select top 3 NOTICENO,NT_TITLE,NT_CONTENT,USERNAME,ADDTTIMEfrom NOTICES where DISPLAY=1)select NOTICENO,NT_TITLE,NT_CONTENT,USERNAME,ADDTTIME from tmp as awhere a.NOTICENO not in (select top 3 NOTICENO from NOTICES)union allselect top 3 NOTICENO,NT_TITLE,NT_CONTENT,USERNAME,ADDTTIMEfrom NOTICES