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 icon1A response icon1
InQuick InsightbyChamathka Maddugoda·Apr 9Filtering Duplicate Rows in SQL with ‘ROW_NUMBER()’Have you ever worked with a SQL table, found duplicate records and wondered how to identify the exact rows causing the issue? Then this…
Tarun·Feb 16How do Spark functions differ from traditional SQL functions?The world of data processing is no longer confined to the rigid structure of a single relational database. As organizations migrate to…
InDatabricks for StartupsbyDanny Park·Dec 12, 202512 Days of Demos: Standardizing North Pole Queries with UC FunctionsDay 5 of 12 Days of Demos
Ankur Gupta·Aug 31, 202510 SQL Functions Every Data Engineer Should KnowFrom cleaning messy data to ranking records, these SQL tricks will save you hours
Ariel Felix·Aug 11, 2025Funções de AgregaçãoAgora que já sabemos o que são funções e exploramos os exemplos de funções de String, vamos trabalhar com funções de Agregação.
