InTDS ArchivebyGiorgos MyrianthousRANK() vs DENSE_RANK() vs ROW_NUMBER() in SQLUnderstanding the difference between these window functions in SQLMar 6, 2023Mar 6, 2023
InLevel Up CodingbyYoussef Hosni13 SQL Statements for 90% of Your Data Science TasksStructured Query Language (SQL) is a programming language designed for managing and manipulating relational databases. It is widely used by…Feb 27, 202360Feb 27, 202360
Felipe HoffaBigQuery performance tips: Searching for text 8x faster — “LOWER() is slower” (DEPRECATED)I was stunned when some of my BigQuery queries were taking a minute or so, instead of the usual few seconds. The culprit: Case insensitive…Feb 1, 20184Feb 1, 20184
InTDS ArchivebyEdwin TanHow to Query SQL Databases Without Writing SQL QueriesConvert questions in plain English into SQL queriesFeb 14, 20221Feb 14, 20221
