New posts in nested-queries

Are SELECT type queries the only type that can be nested?

mysql sql postgresql common-table-expression nested-queries