Kumar·Sep 25Database LanguagesDatabase System support two type of languages, the first language that can specify the schema and the second language express queries and…
Kumar·Sep 23Database Instances And Database SchemasDatabase Instances : The collection of information stored in a database at a particular moment is called instance of a database.
Katie Kaczmarek·Aug 27Window frames in BigQuery: the bit of window functions everyone skipsI remember the moment I first hit this and got properly stuck. I’d written LAST_VALUE(value) OVER (ORDER BY date ASC) and expected it to…
Sahilnayak·Aug 15Window Functions and their use casesI used to be confused about the difference between SQL window functions and how they are actually used. To make things simpler, I have…
InCodeToDeploybyThink Data·Aug 14ROW_NUMBER vs. RANK vs. DENSE_RANK: The Question That Reveals If You Actually Get ItThree functions, three different answers to the same question: what should happen when rows tie?A response icon1
