79493425

Date: 2025-03-07 20:55:06
Score: 3
Natty:
Report link

What about a Common Table Expression ?

WITH b AS (
    SELECT b.id, b.column1, b.column2, func(b.id) AS func_result
    FROM Blog b
)
SELECT p.*, b.*
FROM b
JOIN Post p ON b.id = p.b_id;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Ends in question mark (2):
  • Starts with a question (0.5): What
  • Low reputation (0.5):
Posted by: Alessandro Vecchio