sql - 返回有限记录的 SQL 语句

Question

在 SQL 语句中222，如何返回具有status和 has555的order 和with以及with666PROFESSIONALCOFFERNLIFESTATUSA

ORDER_NO    PRODUCT_CODE    STATUS  OFFER
------------------------------------------
111         PROFESSIONAL    A       NULL
222         PROFESSIONAL    C       N
222         LIFE            A       NULL
333         PROFESSIONAL    A       NULL
444         PROFESSIONAL    A       NULL
555         PROFESSIONAL    C       N
555         LIFE            A       NULL
666         PROFESSIONAL    C       N
666         LIFE            A       NULL

标签： sql

Answer 1

如果我正确理解了你的问题。它应该很简单：

select
    ORDER_NO
from
    YOUR_TABLE_NAME
where
    (PRODUCT_CODE = 'PROFESSIONAL' and STATUS = 'C' and OFFER = 'N') or
    (PRODUCT_CODE = 'LIFE' and STATUS = 'A')