Calculate Year over Year and Quarter over Quarter percent change2

postgresql

Anonymous 2139Anonymous 2139

5If the table is guaranteed to have exactly one row for every quarter, you could try using the `LAG` analytic function to fetch a previous `spend_dollars` value:

Andriy M

Turn on Oracle Spatial in db<>fiddle?

dbfiddle

User1973User1973

find out the count of users who transacted for the first time on a Monday

mysql

ShivaShiva

Executions count reported by sp_QuickieStore 7

sql-server-2016

Anonymous 2148Anonymous 2148

7Hi there!

meme

sql server query error4

sql-server

Anonymous 2135Anonymous 2135

5This condition that compares `shour` with `datetime` is the problem:

ypercubeᵀᴹ

Installing SQL for Mere Mortals databases with MySQL.

anoldmanintheseaanoldmaninthesea

1After connecting to a database, we just need to run the SQL files, following the proper order. First the 00's, then 01's and then the 02's.

anoldmaninthesea

PostgreSQL: Why does my foreach loop not work?4

postgresql

MoshinokiMoshinoki

5`foreach` is a PL/pgSQL structure. You can not use it in a SQL statement.

Truilus

Every Fiddle has "Run failed" error message.19

Anonymous 2070Anonymous 2070

5Thanks Adam, all ~~except Oracle~~ are now working.

Jack Douglas

Query to get the count of users whose first transaction was on a Monday for each merchant

mysql

Anonymous 2043Anonymous 2043

2It would be easier to write a query if you provide test data.

FoggyFinder

db fiddle, Markdown export, Firebird

dbfiddlefirebird

AriochArioch