sql

15632 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How can I create a column with the number of months since a user joined (first date for each id), and group all ids that joined on that month in SQL?
user_117920400
•
1
1
32
snowflake-cloud-data-platform sql
Complex SQL query to generate percentage reports in PostgreSQL
user_173774360
•
1
2
74
postgresql sql
Difference between (TABLOCKX) and (TABLOCKX, HOLDLOCK)
user_65508700
•
2
1
346
tsql sql-server sql
Does Jdbi3 guarantee rollback on transaction for every type of Exception?
user_3996370
•
2
1
205
jdbi3 jdbi sql java
How to delete JSON Object from JSON array in Postgres?
user_163314840
•
1
3
1033
jsonb postgresql sql
sql for Group By and SUM with date range condition
user_54631690
•
1
1
197
group-by mysql sql
Find distance between cities in spatial table
user_105861250
•
1
1
70
postgis spatial postgresql sql
Snowflake how to parse any date or date-time values into YYYY-MM-DD?
user_39227270
•
2
1
185
snowflake-cloud-data-platform data-warehouse sql
Snowflake date shifted by 1 day when importing the data into R
user_160247090
•
2
1
140
snowflake-cloud-data-platform r sql
SQL hierarchyid type issue
user_173535400
•
1
1
37
tsql sql-server sql
Hot Questions