i have Items table: item_id | date | item_price | ---------+-------------+-------------- 1 | 2022-12-05 | 15 | 2 | 2022-02-14 | 12 | 1 | 2022-11-12 | 50 | 4 | 2022-01-21 | 13 | 1 | 2021-12-12 | 10…
I have a database of many thousands of companies. The issue I have is that some of these employers are duplicates - however - they don't have exactly the same name (otherwise this would be quite easy to solve). So…
I'm using Oracle 19c and was wondering if you could take a JSON object like this... { "Employees": [ { "EMPLOYEE_NUMBER": "XXX-XX-XXXX", "FIRST_NAME": "John", "LAST_NAME": "Doe", "TAX_YEAR": "2022" }, { "EMPLOYEE_NUMBER": "XXX-XX-XXXX", "FIRST_NAME": "John", "LAST_NAME": "Doe", "TAX_YEAR": "2021" } ]…
I'm trying to write a query that will show me the difference between the current value and the previous one from the query result. It seems to me that this can be done with the "OFFSET" or "LEAD" method. But…
I want to select from table C all items ID where column A "item_a_id" and column B "item_b_id" not in result of another query. currently I use this query twice , i didnt find a way how to query it…
Having a table T1 contains TITLE age 5 alton john live show must go on Having a table T2 contains NAME. DESCRIPTION John Bo alton for kids Alton show age kids I would like to split TITLE (T1) and check…
I need to replace H2 with PostgreSQL at the WSO2 API Manager. Since there is currently data saved on H2, I need to pass it to PostgreSQL. I found the command SCRIPT TO 'dump.sql' to export the data to .sql…
There are 2 tables Contacts & BlockedEntries Table: Contact Id FirstName LastName Email JobTitle Table: BlockedEntries Id Email Trying to find the entries from contact table with more than one occurence of blockedEntries SELECT email, COUNT(*) as cc, GROUP_CONCAT( id…
How do I get the count/sum of the rows (COUNT () or SUM ()) based on another column (of the Type: weekly or yearly)? I have two tables: Stores: Id Name Type 1 Store 1 Weekly 2 Store 2 Yearly…
How to select more than one value from a 'non-existing' table. For example: SELECT ('val1', 'val2') as "test" How to make a column "test" with two values/rows val1 and val2?