Podzapytanie jednokolumnowe

select * from tabela1
where
kolumna1 = (select kolumna1 from tabela2
where kolumna2 = 'Wartosc')


select * from tabela1
where
kolumna1 IN (select kolumna1 from tabela2
where kolumna2 IN ('Wartosc1', Wartosc2'))


select * from tabela1
where
kolumna1 IN (select kolumna1 from tabela2
where kolumna2 IN ('Wartosc1', 'Wartosc2'))
and
kolumna3 = (select kolumna3 from tabela3
where kolumna3 = 'Wartosc3')


Podzapytanie wielokolumnowe

select * from tabela1
where
(kolumna1, kolumna2) in (
select kolumna1, max(kolumna2) from tabela1
group by kolumna1)


select * from tabela1
where
kolumna1 >ANY (select kolumna1 from tabela1
where kolumna2 = 'Wartosc1")


select * from tabela1
where
kolumna1 > (select min(kolumna1) from tabela1
where kolumna2 = 'Wartosc1')


select * from tabela1
where
kolumna1 >ALL (select kolumna1 from tabela1
where kolumna2 = 'Wartosc1")


select * from tabela1
where
kolumna1 > (select max(kolumna1) from tabela1
where kolumna2 = 'Wartosc1')