首页 > 试题广场 >

select * from tablename where

[单选题]
select * from tablename where columnA=’a’ union select * from tablename where columnB=’b’ 与此查询语句等价的选项是
  • select * from tablename where columnA=‘a‘ and columnB=‘b‘
  • select * from tablename where columnA=‘a‘ or columnB=‘b‘
  • select * from tablename where columnA=‘a‘
  • select * from tablename where columnB=‘b‘
union 关键字的意思是并集去重
发表于 2018-09-24 20:50:55 回复(0)