Sup. Noob dev here. I have one table that stores ITEMS and another with PRICES. Prices one is multiple rows per item, if someone updates the price it appends the table with another row with the date that the price…
I have 2 tables where I need to update one column with the records from the other table: create table abc(id,b,c)as values ('ab1', 1, null) ,('ab2', 2, null) ,('ab3', 3, null) ,('ab4', 4, null) ; alter table abc add constraint…
Following up on from my previous question: Get count of each email type from multiple tables I had to get clarification... So I do indeed need to have multiple tables. I then need to get a count of all the…
I have 15+ tables with emails. I need to count how many emails exist for each internet service provider, like GMAIL, VMG, MSFT, or Other. Using the below query, I can get a count of the ISPs for one table:…
I have two dates and I need to check that these two dates are within the same month of the same year. I have the following solution select to_char(:date1::date, 'yyyymm')::int2 = to_char(:date2::date, 'yyyymm')::int2 who has a better solution?
This might be a bit elaborate so please bear with me. I'm looking to create a new column free_duration in a table that currently looks like this, when grouped by country and product in ASCENDING order of month- month country…
I'm able to create the table using CTE with select statement like below but it's not behaving like I want. with sorting(item_code, index) as ( select (10001, 1), (10002, 2) ) select * from sorting Table result : item_code|index |…
I have two SQL queries like this for postgresql: The first query is fetching subscriptions that were never synced or that were updated recently and synced a long time ago: SELECT * FROM subscriptions WHERE (last_sync_at IS NULL OR last_sync_at…
I am trying to replace the value of one of the columns in the SELECT result to 0. Normally I can do: SELECT 0 AS column_to_set, other_col_1, other_col_2, ... FROM tbl However, there are lots of "other_cols" in the source…
I have a query that performs a count operation on a table with a specific condition. I expected that using an index would be enough to speed up the query, but the output from EXPLAIN ANALYZE indicates a full table…