sql

15632 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How would I join two tables in MySQL (many to one) and get a specific JSON output (as shown below)
user_186298270
•
1
1
410
mysql-python mysql arrays sql json
Transposing multiple related columns
user_139089010
•
1
2
64
cross-apply unpivot tsql sql-server sql
How to select data between two datetimes which are related to certain ID in postgresql
user_189103430
•
1
3
19
postgresql sql
Records not getting inserted in specified POSTGRES DATABASE PARTITION
user_159608260
•
2
0
48
database-partitioning psycopg2 postgresql sql
Using string matching like grepl in a dbplyr pipeline
user_55965340
•
3
1
82
dbplyr stringr dplyr r sql
AWS Athens regexp_extract
user_87107610
•
1
2
146
presto amazon-athena amazon-web-services sql regex
SQL select with three tables and foreign keys
user_155066600
•
1
1
218
select join foreign-keys sql database
How do I return all results of an inner join when filtering by an attribute of a joined table
user_130213280
•
1
1
49
postgresql sql javascript database
Update column with values from another table if ID exists in another table
user_154000340
•
1
1
910
tsql sql-server sql
How PostgreSQL WHERE clause work in this query?
user_41708920
•
3
1
94
postgresql sql
Hot Questions