programming mysql MySQL IF EXISTS

Hướng dẫn mysql case when exists - trường hợp mysql khi tồn tại

Tôi đang cố gắng kiểm tra xem ID có mặt trong một truy vấn con hay không. Tôi đã chạy chỉ số phụ và nó tạo ra một danh sách tất cả các ID có phí chống lại nó, vì vậy những gì tôi muốn làm là kiểm tra xem ID trong truy vấn chính có trong trình điều khiển phụ hay không. Nếu nó có mặt thì hãy trả lại 1, khác trở lại 0. Đây là một truy vấn dễ dàng nhưng tôi không biết mình đang sai ở đâu, tôi đã thử sử dụng exists thay vì in nhưng điều này cũng không hoạt động.

case when debtor._rowid in [
          select distinct note.debtorid from note 
              left join debtor on note.debtorid = debtor._rowid
              left join fee    on fee.debtorid = debtor._rowid
          where fee.type = "Enforcement" and note.type = "Stage"] 
     then 1 else 0 end] as `Enforcement`

Dưới đây là toàn bộ mã, khi tôi xóa mã trên khỏi truy vấn chính bên dưới, nó hoạt động hoàn hảo, vì vậy có điều gì đó không ổn trong tuyên bố trường hợp của tôi.

with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2

13.2.11.6 & NBSP; Các nhóm phụ có tồn tại hoặc không tồn tại

Nếu một công cụ con trả về bất kỳ hàng nào, EXISTS subquery là 

with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
0 và 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
1 là 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
2. Ví dụ:

SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];

Theo truyền thống, một truy vấn con 

with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
3 bắt đầu với 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
4, nhưng nó có thể bắt đầu bằng 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
5 hoặc 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
6 hoặc bất cứ điều gì. MySQL bỏ qua danh sách 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
7 trong một truy vấn con như vậy, vì vậy nó không có gì khác biệt.

Đối với ví dụ trước, nếu 

with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
8 chứa bất kỳ hàng nào, thậm chí các hàng không có gì ngoài các giá trị 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
9, điều kiện 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
3 là 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
0. Đây thực sự là một ví dụ không thể xảy ra bởi vì một truy vấn con 
SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
2 hầu như luôn luôn chứa các mối tương quan. Dưới đây là một số ví dụ thực tế hơn:

  • Những loại cửa hàng có mặt trong một hoặc nhiều thành phố?

    SELECT DISTINCT store_type FROM stores
  WHERE EXISTS [SELECT * FROM cities_stores
                WHERE cities_stores.store_type = stores.store_type];

  • Loại cửa hàng nào có mặt ở No City?

    SELECT DISTINCT store_type FROM stores
  WHERE NOT EXISTS [SELECT * FROM cities_stores
                    WHERE cities_stores.store_type = stores.store_type];

  • Những loại cửa hàng có mặt ở tất cả các thành phố?

    SELECT DISTINCT store_type FROM stores s1
  WHERE NOT EXISTS [
    SELECT * FROM cities WHERE NOT EXISTS [
      SELECT * FROM cities_stores
       WHERE cities_stores.city = cities.city
       AND cities_stores.store_type = stores.store_type]];

Ví dụ cuối cùng là truy vấn 

SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
3 được lồng đôi. Đó là, nó có một mệnh đề 
SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
3 trong mệnh đề 
SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
5. Chính thức, nó trả lời câu hỏi mà một thành phố có tồn tại với một cửa hàng không có trong 
SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
6 không? Nhưng dễ dàng hơn để nói rằng một 
SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
5 được lồng vào câu hỏi là 
SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
8 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
0 cho tất cả 
SELECT DISTINCT store_type FROM stores
  WHERE EXISTS [SELECT * FROM cities_stores
                WHERE cities_stores.store_type = stores.store_type];
0?“does a city exist with a store that is not in 
SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
6”? But it is easier to say that a nested 
SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
5 answers the question “is 
SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
8 
with cte_1
as
[
    select 
        debtor._rowid as casref
        ,concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']] as `F/Y`
        ,date_format[debtor._createddate, '%M %Y'] as `Loaded Month`
        ,ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-'] as `LO F/Y`
        ,coalesce[date_format[debtor.offence_date,'%M %Y'],'-'] as `Liability Order Month`
        ,scheme.name as  `Scheme`
        ,branch.name as `Branch`
        ,count[debtor._rowid] as `Cases Received`
        ,count[debtor.linkid] as `LinkID`
        ,[case 
            when concat[date_format[date_sub[debtor._createddate, interval 3 month], '%y'], '/', date_format[date_add[debtor._createddate, interval 9 month], '%y']]
             = ifnull[concat[date_format[date_sub[debtor.offence_date, interval 3 month], '%y'], '/', date_format[date_add[debtor.offence_date, interval 9 month], '%y']],'-']
             then 1 else 0 end ] as `Same Year`
        , case when debtor._rowid in [
                    select distinct note.debtorid from note 
                        left join debtor on note.debtorid = debtor._rowid
                        left join fee    on fee.debtorid = debtor._rowid
                    where fee.type = "Enforcement" 
                    and note.type = "Stage"] 
                then 1 else 0 end] as `Enforcement`

        from debtor
        left join clientscheme          on debtor.clientschemeID = clientscheme._rowid
        left join scheme                on clientscheme.schemeID = scheme._rowid
        left join branch                on clientscheme.branchID = branch._rowid
        left join fee                   on debtor._rowid = fee.debtorid
        left join note                  on debtor._rowid = note.debtorid
    where clientscheme.branchID in [1,10,24]
    and debtor._createddate >= '2017-04-01'
    group by debtor._rowid
]
,
cte_2
as
[
select 
    `F/Y`
    ,`Loaded Month` 
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,sum[`Cases Received`] as `Case Count`
    ,sum[`LinkID`] as `Linked Accounts`
    ,sum[`Same Year`] as `In Year LO`
    ,sum[Enforcement] as `Enforcement Applied`
from cte_1
group by 
    `Loaded Month`
    ,`Liability Order Month`
    ,`Scheme`
    , `Branch`

]

select 
    `F/Y`
    ,`Loaded Month`
    ,`LO F/Y`
    ,`Liability Order Month`
    ,`Scheme`
    ,`Branch`
    ,`Case Count`
    ,`Linked Accounts`
    ,round[[`Linked Accounts`/`Case Count`],2] * 100 as `% of Linked Accounts`
    ,round[[`In Year LO`/`Case Count`],2] * 100 as `In Year LO's`
    ,`Enforcement Applied`
from cte_2
0 for all 
SELECT DISTINCT store_type FROM stores
  WHERE EXISTS [SELECT * FROM cities_stores
                WHERE cities_stores.store_type = stores.store_type];
0?”

Trong MySQL 8.0.19 và sau đó, bạn cũng có thể sử dụng 

SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
3 hoặc 
SELECT column1 FROM t1 WHERE EXISTS [SELECT * FROM t2];
5 với 
SELECT DISTINCT store_type FROM stores
  WHERE EXISTS [SELECT * FROM cities_stores
                WHERE cities_stores.store_type = stores.store_type];
3 trong truy vấn con, như thế này:

SELECT column1 FROM t1 WHERE EXISTS [TABLE t2];

Các kết quả giống như khi sử dụng 

SELECT DISTINCT store_type FROM stores
  WHERE EXISTS [SELECT * FROM cities_stores
                WHERE cities_stores.store_type = stores.store_type];
4 mà không có mệnh đề 
SELECT DISTINCT store_type FROM stores
  WHERE EXISTS [SELECT * FROM cities_stores
                WHERE cities_stores.store_type = stores.store_type];
5 trong truy vấn con.

Bài Viết Liên Quan

Hướng dẫn how do i install python 2 on windows? - làm cách nào để cài đặt python 2 trên windows?
O cung trong linux
Hướng dẫn how to run two infinite loop in python - cách chạy hai vòng lặp vô hạn trong python
Hướng dẫn why is enumerate used in python? - tại sao liệt kê được sử dụng trong python?
Hướng dẫn how do you shuffle data in python? - làm cách nào để xáo trộn dữ liệu trong python?
Giọng hát việt 2023 tập 1
Hướng dẫn remove comma from last element in array php - xóa dấu phẩy khỏi phần tử cuối cùng trong mảng php
Traàn ram máy chủ linux
Hướng dẫn laragon php path - đường dẫn laragon php
Hướng dẫn str_split php - str_split php
Hướng dẫn python global class function - hàm lớp toàn cầu của python
Hướng dẫn exceljs multiple tables - exceljs nhiều bảng
Hướng dẫn dùng df append python
Hướng dẫn intersection of two array of objects javascript - giao điểm của hai mảng đối tượng javascript
Hướng dẫn how do you generate the next permutation in python? - làm cách nào để tạo hoán vị tiếp theo trong python?
Hướng dẫn can i use javascript variable in php? - tôi có thể sử dụng biến javascript trong php không?
Hướng dẫn python dynamic function - hàm động python
Cho nick free fire 2023
Hướng dẫn normal distribution histogram python - phân phối bình thường histogram python
Hướng dẫn dùng c# gettype trong PHP

Toplist mới

#1
Top 7 tết mậu thân năm 1968 đã diễn ra sự kiện gì ở miền nam nước ta 2023
6 tháng trước
#2
Top 13 luyện từ và câu: dấu gạch ngang lớp 4 trang 45 2023
6 tháng trước
#3
Top 6 trong mặt phẳng oxy ảnh của đường thẳng d 3x y 4=0 2023
6 tháng trước
#4
Top 6 thử thách thần chết thuyết minh phần 2 2023
6 tháng trước
#5
Top 4 vở bài tập tiếng việt lớp 3 tập 2 chính tả trang 15 2023
6 tháng trước
#6
Top 5 áo khoác nam quảng châu cao cấp 2023
6 tháng trước
#7
Top 4 nội dung nào sau đây không phải là trách nhiệm của đơn vị đầu mối cung cấp thông tin 2023
6 tháng trước
#8
Top 9 mẫu đồng phục công sở đẹp 2022 2023
6 tháng trước
#9
Top 5 ốp lưng iphone 13 pro bảo vệ camera 2023
6 tháng trước

Bài mới nhất

Cải làm dưa chua là cải gì năm 2024
Các sản phẩm làm đẹp tiếng anh là gì năm 2024
Bán hàng phát sinh giảm giá hoạch toán tn năm 2024
Lá thư trong tiếng anh là gì năm 2024
Mẫu hợp đồng thanh toán qua bên thứ 3 năm 2024
Giải sách bài tập tiếng anh lớp 7 trang 8 năm 2024
1994 sinh con năm 2023 tháng nào tốt năm 2024
Dịch vụ chuyển văn phòng tại thanh hóa năm 2024
Cách khắc phục lỗi máy tính bị màn hình xanh năm 2024
Các trường của 1 đối tượng là gì năm 2024

Chủ Đề

programming Hỏi Đáp Là gì Mẹo Hay Toplist Địa Điểm Hay Học Tốt mẹo hay Công Nghệ Nghĩa của từ Bao nhiêu Khỏe Đẹp đánh giá Tiếng anh Top List bao nhieu bao nhiêu hướng dẫn Món Ngon So Sánh Bài tập So sánh Xây Đựng Sản phẩm tốt Ngôn ngữ Bài Tập javascript Ở đâu Thế nào Hướng dẫn Dịch Tại sao Máy tính Đại học