Challenges students face when learning to work with relational databases and SQL

Re:Challenges students face when learning to work with relat... by moonchrome on Sunday August 29, 2021 @07:32PM (#28351463)

Have some links on using CTEs to replace nested queries and how it helps ?

I've used SQL enough to have to write nested queries, haven't dove further than that.

[ Parent | on HN ]

Re:Challenges students face when learning to work with relat... by ducharmdev on Monday August 30, 2021 @09:20AM (#28355367)

Here's an article with some examples:

https://learnsql.com/blog/sql-subquery-cte-difference/

You can think of CTEs as a way to save an intermediate query as a sort of temp variable/table that can be used in the final statement following `WITH something AS (...)`. They are great for flattening your queries and giving descriptive names to subqueries, and you can chain multiple WITHs together as well.

[ Parent | on HN ]