I've got this table in Postgres: create table test("Product id", "Product Name", "Category", "Operator", piece) as values (10, 'Carbonara', 'C1', 'User1', 1) ,(11, 'Spaghetti', 'C1', 'User2', 1) ,(12, 'Coke', 'C2', 'User1', 1) ,(10, 'Carbonara', 'C1', 'User2', 2) ,(11, 'Spaghetti', 'C1',…
I am working in Postgresql and am trying to find what table a specific word is in. For example, I am trying to find out what table the word "banana" is in. The database is agriculture and schema is fruit.…
Here's the problem statement Write a solution to select the product id, year, quantity, and price for the first year of every product sold. Input: Sales table: +---------+------------+------+----------+-------+ | sale_id | product_id | year | quantity | price | +---------+------------+------+----------+-------+…
When I run this request I get an error recursive query "cte_0" column 1 has type date in non-recursive term but type timestamp without time zone overall LINE 4: select min(to_char(date_trunc('month', day), 'yyyy-mm-d... ^ HINT: Cast the output of the…
Trying to load a nested JSON file into Duckdb. Here is the JSON contents: { "MainLevel":[ { "More":{ } }, { "More":{ "Level2":[ { "Field1":"A" } ] } } ] } This is the Duckdb SQL script I am using…
Given the below, WITH cte AS ( SELECT employeeId, employeeName, ROW_NUMBER() OVER (PARTITION BY employeeName ORDER BY employeeId asc) AS rn FROM duplicateEmployee ) SELECT * FROM cte WHERE rn > 1 I need to count the duplicate records without…
I have performance issue on a query, potentiall wrongly written. Dear all. I have two tables. One table "test_cdr" , with rougly 5M rows, contains three columns POINT_TARGET | Contains called phone numbers dest | should contain a destination identifier…
I have a model with QR codes that has a field called type. This field can have two values: 1 (Plate) or 2 (Sticker). I could simply create an enumeration of these types as an array in the model and…
I would like to count the waves available (LEFT OUT JOIN). My problem is that I also have another LEFT OUTER JOIN on invitations. The idea is to have all the stats from the same SQL request. Stats from invitations…
I'm trying to figure out how to insert new data into a database while explicitly setting the ID. However, when I use nextval('user_seq'), it doesn't retrieve the next value from the sequence as expected; instead, it increments it based on…