In a Postgres DB I have entries for "events", associated with an id, and when they happened. I need to count them with a special rule. When an event happens the counter is incremented and for the next 14 days…
I have below price audit table in timescale db. When I get new price I should calculate minimum price in last 30 days. But our price data not daily. In every price changes I write date and price to table.…
I got that table CREATE TABLE test ( P_IP varchar(255), MAC varchar(255), R_IP varchar(255), dates TIMESTAMP ); Every column can be duplicate. Each row is report by timestamp I wanna get the latest row unique mac by timestamp. and if…
I want to get the first two items of each month for each person. The idea is if the item have the same date, it should return the largest amount instead. I am having trouble writing a simple logical condition…
I have a PHP application that is running on a LAMP stack. This application makes an API call back to the server via javascript to get more data to display on the screen every second. When there are a number…
Tables and data: CREATE TABLE major ( id INT PRIMARY KEY, name VARCHAR(200) ); insert into major values (101, 'Computing'), (102, 'Arquitecture'); CREATE TABLE student ( id INT PRIMARY KEY, name VARCHAR(200), major_id INT, foreign key(major_id) references major(id) ); insert…
I have a query something like SELECT S.product_id, S.link, C.id AS category_id FROM Products P INNER JOIN SEO S ON S.product_id = P.id AND P.product_type = 1 LEFT OUTER JOIN Categories C ON c.product_id = P.id WHERE P.active = 1…