I have a postgres table Article which has three columns - title, description, categories. All the three columns contain plain text. I have 2 search words - say word1, word2 I want to find the records where title+description+categories contains all…
I have two tables joined orders (id) and order_status (id, order_id, status_id). I want to return only the orders that doesn't have a given status_id, I've tried: SELECT order_id FROM orders INNER JOIN order_status ON orders.id = order_status.order_id WHERE order_status.status_id…
I have a COLUMN in a Postgres table which has values with the following pattern. INPUT-X INPUT-X-Y INPUT-X-Y-Z INPUT-X-Y-Z-A-... I am trying to count the number of entries in COLUMN where the value begins with INPUT and contains a given…
I have my table like this: WITH my_table (user_id, date, event_name, value) AS ( values (1,'2021-10-01', 'level', 5), (1,'2021-10-03', 'purchase', null), (1,'2021-10-05', 'purchase', null), (2,'2021-10-02', 'level', 10), (2,'2021-10-03', 'purchase', null) ) SELECT * FROM my_table user_id date event_name level 1…
I'm trying to figure out a way to reason about a fairly simple problem: A table foo has two columns, id with unique identifiers, and value with a random numeric value. Given a constant threshold value, find the groups of…
Suppose I have a user's count of visit for each countries: The query goes: SELECT countries_users.user_id, countries.name, count(countries_users.id) as count_visit FROM countries_users LEFT JOIN countries on countries.id = countries_users.user_id WHERE countries_users.user_id IN (111, ...) GROUP BY countries_user.user_id, countries.id The result…
I'm Newbie in postgres. I wrote a function, which insert into table a data by portions(because there is too much data in the source table to do it all at once) from another table: CREATE OR REPLACE FUNCTION data_load(p_src_schema character…
This is the code that is supposed to return an html report by and ssms job. DECLARE @DataInicialMesAnterior DATE, @DataFinalMesAnterior DATE; SET @DataInicialMesAnterior = DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0); SET @DataFinalMesAnterior = DATEADD(DAY, -1, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()),…
i have a table like this: name used time asd 10 15:00 bsf 15 15:00 asd 20 14:55 bsf 0 14:55 i need to make a query that returns values like this: the result i need for the grafana timeseries…
I have two Postgres tables: 'user' with unique rows, and 'address' where a single user can have multiple addresses. I want to join specific 'user' row with one row from 'address' where the address.id is the highest max(id). I wrote…