Oracle glossary: Subquery

Oracle glossary: Subquery
  • 23
    Set

Oracle glossary: Subquery

twittergoogle_pluslinkedin

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.