sql

15632 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How to convert Array(Struct(Struct)) to Array(Struct) in Azure Databricks SQL
user_193300190
•
1
1
199
azure-databricks sql
postgresql employee inherits manager data for missing values
user_112868150
•
2
1
38
recursive-query hierarchical-data postgresql sql
Regex: return contents of parentheses unless substring is present inside, then return everything outside parentheses
user_130448780
•
2
1
50
sql python regex
Update a column based on list
user_168917290
•
1
2
55
python-3.x sql python
Changing the format of the entire column in a mysql table
user_191717810
•
1
1
30
mysql sql
Use St_ExteriorRing, or similar, to fill up 'holes' in Multipolygon geojson
user_9166910
•
2
1
88
multipolygons geojson postgis postgresql sql
Collapse vertex rows into nested table type (aggregated by ID)
user_55767710
•
2
1
70
oracle-spatial oracle18c oracle sql
COUNT all values in a column with JOIN
user_183232700
•
3
3
87
left-join count join mysql sql
Splitting partition and removing partition scheme
user_155745020
•
1
1
61
database-partitioning sql-server sql
Choosing values based on an order in a list using SQL
user_93932180
•
2
1
31
snowflake-cloud-data-platform sql
Hot Questions