Simplify Complex SQL With This Feature

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
There's a technique in SQL that allows you to simplify your queries and possibly improve performance.
Learn what it is, why use it, and how to use it with some examples in this video.
🔗 VIDEO LINKS:
GitHub repo with the scripts from this lesson: github.com/bbrumm/databasesta...

[@jimshtepa5423]

what is a session in this context? say 25 users are looking at their historic data (performance on task completing), is a temporary table created by the first user queried relevant data will survive until the last 25th user closes her browser tab?

[@DatabaseStar]

Good question. A session is a single user within their own connection to a database. If 25 users are viewing the database, they each have their own separate session. A temporary table can be created, and will only exist and be populated for that user. Once a user disconnects or closes their tab, the session will end.

[@ravishmahajan9314]

CTE are better than temp table

[@DatabaseStar]

Yeah they can be in many situations.