Definition A named, temporary result inside a SQL query that makes long queries easier to read and reuse.
Also called CTE, Common table expression
For your role Your role Choose your role Accounts payable Credit controllers FP&A analysts Finance business partners Finance directors and CFOs Financial controllers Management accountants Payroll specialists Account executives Sales managers Sales operations analysts Sales representatives Bid and tender managers Commercial directors New to business Pricing analysts Revenue managers Senior leaders Campaign managers Communications managers Customer insight analysts Digital marketing managers Marketing analysts Marketing directors HR business partners HR directors Learning and development managers People analysts People managers Recruiters Operations analysts Operations directors Operations managers AI product managers Heads of product Product analysts Product managers Product owners Machine learning engineers Analytics engineers Data analysts Data architects Data engineers Data governance leads Data privacy officers Data scientists Information architects Platform engineers Report builders Business analysts Corporate development managers Heads of strategy Strategy analysts
Choose your role to see what this term means in your work.
Why it matters It makes complex SQL easier to read, check and maintain.
Where it is used SQL code reviews and analytics queries.
