I started to SET my dates to (%d. %M %Y). But now I cant find them with: SELECT value FROM _data WHERE dates >= "01. October 2012" AND <= "01. December 2016" The default DATE_FORMAT was YYYY-MM-DD hh:mm:ss.000 before the…
I'm trying to return a sorted list of entries by their date, but keep matching columns together. For a super simplified example, the table food is as follows. id name group_uuid date 1 Apple 6d37ca 2023-05-20 2 Cucumber d90ad2 2023-05-20…
I need to check if a row exists, and if it does - update some column, and if not, create a new record. But the queries I am using are not thread safe, as I do not have unique indexes…
I am trying to get data from a view which returns users name and tags (comma separated numbers). Now I want to get a user if it has a certain tag. My view returns this: id | name | tags…
I have following example: create table products (name text, id integer, type smallint, category integer); insert into products values ('apple', 23, 1, 1200), ('apple', 23, 1, 999), ('apple', 31, 2, 1200), ('apple', 23, 3, 1200), ('orange', 10, 1, 200), ('orange',…
I want to find the newest message entry for each chat_id. For example, for this table I need to get list of rows: with id=1c6bad12 for chat_id=ee5152ff and with id=e4485bdf for chat_id=29cc7217. (2th and 6th). id chat_id created_at text 1442a8e8…
Let's assume there is a table: day amount 1 10 2 20 3 30 I want to know when turnover reached 30, in case above it's happened on 2 day. How to query this in SQL? I guess I have…
Looking to compare today's temperature to yesterday's. If today's is higher than I want to return that row's id. Table has 3 columns: id, RecordDate, and temperature. Code works on small data sets but looking at a data set of…
We have a table bids(id,auction_id, vendor_id,bid_price,created_at) where one vendor will have multiple bids but we take the latest using the created_at column We need to find the position of the vendor from the bids of all vendors where his position…
How to use two aggregate functions (for example double string_agg or just sum), but ensure that the results do not contain duplicates caused by the other aggregate function (caused by second join)? I use PostgreSQL. Example I have three tables:…