I have a table P that looks something like this: ID | Status | Env 1 | 1 | Linux 1 | 1 | Windows 1 | 3 | Mac 2 | 1 | Linux 2 | 1 | Windows 2 | 1 | Mac 3 | 3 | …

I have two SQLite databases which I would like to merge. I’m doing it by using the following commands: ATTACH “c:other.db” AS SecondaryDB INSERT INTO MyTable SELECT * FROM SecondaryDB….

I have two tables one with customer and another with invoices. I need to find all customer that have an more that one invoice with different days with in a period. Invoice table: Accountnum Datein …

I have an input table: input and one or more maptables, where input contains data for multiple identifiers and dates stacked under each other. The schemas are as follows: #input Id: string (might …

I’m trying to construct a DB2 query that returns distinct rows, but for the distinction to be based on only one column’s values. The query below will allow multiple rows with the same order number if, …

I have in a table in MS SQL with multiple entries per user. I am trying to get the top 3 entries by date for each user. I have a query that returns returns the maximum top 3 entries per user but is …

I have a table like this Node_id | channel | timestamp | value | folder_id 242278 | return_status | 2020-07-28 14:29:26 | “Return Created” | …

I’m doing some counts to validate a table XXX, I designed 2 queries to calculate people younger than 18 years. The query i’m using is the following: select count(distinct user.id) from user left join …