sql

15632 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Get common records between two tables based on condition
user_60231730
•
2
3
483
tsql sql-server sql
EditorConfig - Convert tabs to spaces in SQL files transparently
user_9796090
•
2
1
252
editorconfig visual-studio-code format visual-studio sql
How to unpack array as columns
user_181458420
•
2
1
166
presto sql
Aggregate multiple tables considering indexing with values derived from one table
user_9763990
•
4
4
254
azure-sql-server common-table-expression sql-server sql
Transpose indeterminate number of rows into columns?
user_73957550
•
2
2
62
pivot sql-server sql
MySQL how to update multiple rows without breaking unique constraint or using placeholder row
user_157077970
•
2
0
152
uniqueidentifier unique-constraint sql-update mysql sql
Queries on large table extremely slow, how can I optimize?
user_2953020
•
2
1
736
azure-sql-database query-optimization sql-server sql
ORDER BY with a specific value first
user_179168760
•
2
2
59
sql-server sql
Is `lock_timeout` necessary for a Postgres CREATE INDEX CONCURRENTLY
user_2165090
•
3
1
165
postgresql sql
Is there a functionality similar to ctid in postgres for MySQL/Snowflake or other databases?
user_116089620
•
2
1
194
snowflake-cloud-data-platform sqlite mysql sql
Hot Questions