CTEs can be defined in user-defined routines, such as functions, stored procedures, triggers, or views. Using a CTE offers the advantages of improved readability and ease in maintenance of complex queries.