I have a field that is of type jsonb that is structured like: data: { "prices": { "[parent key]": { "price": 20, } } } 'parent key' can be 5 possible values but all I really need is the 'price'…
The EXECUTE statement does not recognize upper case letters on the database name. Running the below query on a database named "ABcdeFG" DO $c$ BEGIN EXECUTE 'ALTER DATABASE ' || current_database() || ' SET client_encoding = $$LATIN1$$'; END; $c$; returns…
I have a table called, 'Songs'. This is the table structure. The table has an AlbumID column, which will be a foreign key reference to the Album table. The Songs table also has a 'status' column. Where it can be…
I have the following example data structure of customer that can be part of multiple groups using a junction table and data: CREATE TABLE customer ( id INT NOT NULL ); CREATE TABLE groups ( id INT NOT NULL );…
I have a table package_scans with fields package_id and scan_id, and another table scan_content with scan_id and epc. There is a 1-N relation between the tables, so for each package_scan there are multiple entries in scan_content. I am trying to…
SELECT d.USPS_IMB AS IMb, d.CorrelationId, d.EINNo AS EIN, d.UniqueFormId AS FormId, d.ProductionFacility AS Facility, CASE WHEN d.ProductionStatusNo < 5 THEN 'Received' WHEN d.ProductionStatusNo = 5 THEN 'Printed' WHEN d.ProductionStatusNo = 6 THEN 'Folded / Sealed' WHEN d.ProductionStatusNo = 7 THEN…
I have two tables, Table_1 and Table_2. I want to compare one of the columns between the tables and have an output of the difference. Specifically, I need to know which entries (of a column) of Table_1 are not present…
I have let's say 100 000 records where 20 records relates to a concrete user. I am looking for confirmation that adding where clause to the query will make offset clause to scan only these 20 rows. e.g. record is…
I have a database backup from where I would like to get all revision for a course, then for its lessons and for each lessons the chapters. The revision of a course was easy enough: SELECT * FROM wp_posts WHERE…
I have a database table that having close to 100 columns - 25 columns are STRING, the rest is INT/DECIMAL/BOOL. This is the query that I am trying to run - the query is generated based on the search criteria…