CTE and WITH Clause in MySQL

What is a CTE?

Example

WITH high_scorers AS (
  SELECT name, marks FROM students WHERE marks >= 90
)
SELECT * FROM high_scorers ORDER BY marks DESC;

Why Use CTEs?

• Break a big query into readable named steps.
• Reuse the same subquery result multiple times.

Summary

• A CTE is a named temporary result defined with WITH.
• Makes complex queries cleaner and more readable.

CTE क्या है?

Example

WITH high_scorers AS (
  SELECT name, marks FROM students WHERE marks >= 90
)
SELECT * FROM high_scorers ORDER BY marks DESC;

CTEs क्यों Use करें?

• बड़ी query को पढ़ने योग्य named steps में तोड़ें।
• एक ही subquery result कई बार reuse करें।

सारांश

• CTE WITH से define किया named temporary result है।
• जटिल queries को साफ और पढ़ने योग्य बनाता है।