Я обзову эти таблицы
Clients и
Filials.
a:
Код:
Select F1.*
From Filials F1
Where Not Exists (
Select *
From Clients C
Where C.N_Filial = F1.N_Filial And Exists (
Select *
From Filials F2
Where F2.N_Filial = C.N_Filial And F1.N_Filial <> F2.N_Filial))
b:
Код:
Select Distinct C1.*
From Clients C1
Where Not Exists (
Select *
From Filials F
Where Not Exists (
Select *
From Clients C2
Where F.N_Filial = C2.N_Filial And C1.FIO = C2.FIO))
c: (вариант
friz неправильный)
Код:
Select C1.FIO
From Clients C1
Where (
Select Count(*)
From Clients C2
Where C1.FIO = C2.FIO) = 1
d: не очень понятен запрос.