Oracle glossary: Subquery

Una subquery è una query sql contenuta in un’altra query sql.
Un po’ di esempi:
select tab.name, tab.surname from
(select name, surname from customer where surname like ‘S%’) tab
select id from myusers where (name, surname) in
(select name, surname from customer where surname like ‘S%’) tab
select (select ‘1’ from dual) from table.

Potrebbero interessarti anche...