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

sqlpostgresqlgaps-and-islands

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

sqloracle-databaseoracle19c

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
How do I sum up each month for all 12 months in one query...

sqlsql-serversum

Read More
how to select precisely column created on dual table...

sqloracle-database

Read More
Window functions: is PARTITION BY the right way to walk through the table?...

sqlpostgresqlwindow-functions

Read More
Execute SQL script from command line...

sqlsql-serverbatch-filecommand-linescripting

Read More
PostgreSQL List of Transactions...

sqlpostgresqltransactions

Read More
fill gaps in outer join in redshift...

sqloracle-databasejoinamazon-redshift

Read More
BackNext