SQL Server How to query multiple combinations in a sql query

rbl8hiat 于 2023-02-21 发布在其他

关注(0)|答案(1)|浏览(217)

I would like to write a query, for e.g.

Select * From dbo.[dataset]

Where _date BETWEEN '2022-..-..' AND '2022-..-..'
--first condition
AND Animal = 'Dog' AND Dog_Colour = 'Beige'
--Second condition
AND Animal = 'Cat' AND Cat_Colour = 'Black'
--next condition..
AND etc...

I'd like to pull a combination of animals and colours together, only when the conditions are met for each line. Can someone help please?

sql-server

来源：https://stackoverflow.com/questions/75512804/how-to-query-multiple-combinations-in-a-sql-query

1条答案

按热度按时间

ruyhziif1#

An SQL OR condition should be good enough for the query.

Select * 
From dbo.[dataset]
Where _date BETWEEN '2022-..-..' AND '2022-..-..'
AND 
(
  --first condition
  (Animal = 'Dog' AND Dog_Colour = 'Beige')
  --Second condition
  OR (Animal = 'Cat' AND Cat_Colour = 'Black')
  --next condition..
  OR ( Animal = 'XXX' AND XXX_Colour = 'YYY' )
)

赞(0）回复(0）举报 2023-02-21

我来回答

SQL Server How to query multiple combinations in a sql query

1条答案

相关问题

热门标签

最新问答