Search code examples
Postgres Fixed 7-day window shifting data...

sqlpostgresqlgaps-and-islands

Read More
How can I take the difference in values between the output of two SQL queries?...

sqlpostgresql

Read More
Ability to extract IDs from one column and return them in their own columns using SQL...

sql

Read More
SQL not a single-group group function...

sqloracle-databasegroup-bysummax

Read More
Find records using max date but exclude time...

sqlsql-serversql-server-2019

Read More
Max function is not filtering results...

sql

Read More
Get List of Months Between Two Dates...

sqloracle-databaseoracle19c

Read More
graph database along with a relational database...

sqlneo4jnosqlgraph-databasesrdbms

Read More
Cannot add foreign key constraint, (no different datatypes)...

mysqlsqlforeign-keys

Read More
Comparison of Relational Databases and Graph Databases...

sqlrelational-databasegraph-databases

Read More
How to find if a company (customer) ordered in a particular month and year and never before? (MySQL)...

sqlmysql

Read More
PostgreSQL: insert from another table...

sqlpostgresqlinsertappend

Read More
MySQL convert column data type from DECIMAL(10,5) to DECIMAL(10,2) shows different SUM outcomes...

sqlmysql

Read More
SQL window functions...

sqllagdense-rankleadpartition-by

Read More
How to assign multiple values for same dimension in SQL...

sql

Read More
VBA - Convert a few numeric cells as text...

sqlexcelvbaformatcell

Read More
SQL- Ignore case while searching for a string...

sqlsql-servercase-insensitivesql-likeignore-case

Read More
MySQL search with selected options only...

mysqlsqlselect

Read More
T-SQL STOP or ABORT command in SQL Server...

sqlsql-servert-sqlsql-scripts

Read More
Oracle query - day / time range...

sqloracle-databasetimerange

Read More
I'm trying to replace not exist in with left join, but my query is not returning the same result...

sqlsubqueryleft-joinnot-exists

Read More
SQL query to select fewest rows that cover all columns...

sqlt-sql

Read More
INSERT VALUES WHERE NOT EXISTS...

sqlsql-server

Read More
How to convert Table to nested JSON in SQL Server 2019...

sqljsonsql-serversql-server-2019

Read More
NoSQL vs. SQL when scalability is irrelevant...

sqldatabasemongodbnosql

Read More
AVG function returns only 1 or 0, Apache Hive...

sqlhivegroupingaverage

Read More
Using array_agg to make array out of N to 1 columns...

sqlpostgresql

Read More
Regular expressions inside SQL Server...

sqlsql-serverregexexpression

Read More
Redshift GROUP BY ALL syntax not supported...

sqlpostgresqlamazon-redshift

Read More
Trim trailing spaces with PostgreSQL...

sqlpostgresqlwhitespacetrimremoving-whitespace

Read More
BackNext