[Solved] Sql request selection

by

[ad_1]

The query below uses a Join which should be faster than a subquery.

    Select t1.ContractId, t2.MissionId 
    From tab t1
    Join tab t2 ON t1.ContractId = t2.ContractId
    Group By t1.ContractId, t2.MissionId 
    Having Count(*) > 1

2

[ad_2]

solved Sql request selection