sql

15632 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How to count distinct over window on months (rather than days)?
user_199927580
•
3
2
59
pyspark apache-spark-sql apache-spark sql
Create table with date shards of the form _YYYYMMDD
user_47969420
•
1
1
55
create-table google-bigquery for-loop sql
PostgreSQL - query to select data from many-to-many tables
user_163377780
•
1
3
37
join postgresql sql json database
What is the difference between COUNT(*) and COUNT(columnname) after joining tables?
user_184505810
•
1
2
40
sql
How to retrieve data from 2 different where?
user_199997460
•
1
6
63
mysql sql
Get only few properties from Postgres JSON column
user_199992930
•
1
1
45
postgresql sql json
Order output by 2 rows from different tables
user_189457980
•
2
0
54
mariadb sql
DBT macro is not returning anything in my dbt model
user_145867610
•
1
1
25
dbt jinja2 macros sql
Multiple INSERT for chained WITH AS in SQL
user_25988760
•
1
1
32
postgresql sql
SQL Limit Results Per Unique Value In Column
user_193138960
•
1
1
19
aggregate group-by postgresql sql
Hot Questions