greatest-n-per-group Archives

How to Speed Up my SQL Query?

By adminPosted on March 16, 2023

Question : I have a query that is taking much longer than I expect it should, and I can not […]

By adminPosted on March 7, 2023

Question : I am working on a query to pair drinks to pizzas. Currently I am able to show the […]

By adminPosted on March 7, 2023

Question : I am looking to migrate our support database from MS SQL Server to Postgres and most of it […]

By adminPosted on March 7, 2023

Question : A table files looks like: id, file_name, vendor_id, created 1, z.txt, 2, 2011 2, z.txt, 2, 2011 3, […]

By adminPosted on February 27, 2023

Question : I’m moving up to the next level of my mystery query. It looks like there’s a subselect inside […]

By adminPosted on February 17, 2023

Question : I have a PostgreSQL database with a history table where I store an fooID (not a primary key […]

By adminPosted on February 17, 2023

Question : Please consider the following table test: CREATE TABLE test(col1 int, col2 varchar, col3 date); INSERT INTO test VALUES […]

By adminPosted on February 16, 2023

Question : Im using MySql 8.0 and I’ve been exercising a lot of quries but this one I cant seem […]

By adminPosted on February 4, 2023

Question : I am using Postgres 9.3.9. I have 2 tables : f_agent : CREATE TABLE f_agent ( f_agent__id bigserial […]

By adminPosted on January 31, 2023

Question : SUBSCRIBER DATE TIME VALUE aaa 23-04-2015 04:04:07 10 aab 23-04-2015 12:04:32 5 bbb 23-04-2015 01:04:05 20 bbb 23-04-2015 […]