Categories
common-table-expression mysql oracle

WITH clause in MySQL?

Does MySQL support common table expressions? For example in Oracle there’s the WITH clause? :

WITH aliasname
AS
( SELECT COUNT(*) FROM table_name )
SELECT COUNT(*) FROM dept,aliasname