- This topic is empty.
-
Posts
-
Difference between queries/subqueries/joins we create using SELECT and another way of Temporary Tables. Also, differences with SQL Window Functions.
Is it true that Temporary Tables are still created to run queries/subqueries/joins with the only difference that codes (queries/subqueries/joins statements) will not be saved for future sessions?
Is it true that the tables created with queries/subqueries/joins are saved and so occupy memory spaces but in case of the Temporary Tables, tables not saved. Codes (queries) are however saved in both the cases.
Not sure how SQL Window Functions compare to the above two except that the feature available perhaps only for Microsoft Windows. What I understand is that Window Functions too perform certain comparison operations on tables that are virtual in nature. I mean virtual tables are created that will not be saved for the next sessions.
Further insight on the above will be helpful and clear confusion of mine.
Reply
- You must be logged in to reply to this topic.
