数据库将查询的多个字段结果合并为一个字段处理(Sql Srever,MySql,Oracle,Postgres)

SqlServer

select * from Table where CAST(字段1 AS VARCHAR(10))+'-'+CAST(字段2 AS VARCHAR(10)) not in ('组合后数据')

MySql

select * from Table where concat_ws('-',字段1,字段2,字段3) not in ('组合后数据')

Postgres

select * from Table where (字段1,字段2,字段3) not in (('1',2,'3'))

Oracle

select * from Table where Concat(Concat(Concat(字段1,'-'),字段2),字段3) not in ('组合后数据')

来源地址：https://blog.csdn.net/weixin_48449171/article/details/131706341