Common table expression is a a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE.