I have 2 tables with a 1-to-many relationship. Table A contains 'OBJECTS' and table B contains 'COMPONENTS' have id's that are related and I wrote a query to gather all OBJECTS from table A and associated COMPONENTS from table B…
I would like to return all the rows that contains a price higher than 123: // Entity Table1 [Column(TypeName = "jsonb")] public List<NewPrice> HistoryPrices { get; set; } public class NewPrice { public int Price { get; set; } public…
I have a table with tax rates. Each tax rate has two date fields: 'valid_from' and 'valid_to'. 'valid_to' can be NULL, then the tax rate is valid until a later tax rate is inserted. Now I want to determine all…
I have this table: dbchatbot=# d messages Table "public.messages" Column | Type | Collation | Nullable | Default -----------------+-----------------------------+-----------+----------+--------- uuid | character varying(36) | | not null | content | text | | | Indexes: "messages_pkey" PRIMARY KEY, btree (uuid)…
I want to find the lowest missing number from two tables For Example, Table1 columna has 1,2,3,8 Table2 columnb has 4,10,11 I want to return 5 I have been able to get the lowest missing number from one table, i.e.…
I have this table: | arrs | |:----| | {10000,10000,10000,10000} | | {100,200,300} | | {400,500,600} | | {100,200,600} | How get this result? | uniques | |:-------| | 10000 | | 100 | | 200 | | 300 |…
Say I have a table with dates and associated data for each date. I want to select every date, but only show the associated data if it matches a WHERE clause, otherwise just fill it with NULL. The goal is…
I have a .sql file with CREATE TABLE AND INSERTS TABLE sentences in it. Example: INSERT INTO `examle` (`myid`, `title`, `value`, `usefull`, `picture`, `short_description`, `description`, `wikipedia`, `category`, `date`) VALUES (1, 'Cat', '3,45', 'No', 'cat.jpg', 'A very useless domestic cat.', 'The…
I need to update jsonb column by jsonb_set, to use jsonb_set, need a full Json Path. How could I get full jsonb path when jsonb has list? For example, I got a JSON : { "Laptop": { "brand": "Dell", "price":…
So I have a result like this gotten from multiple LEFT JOIN statement where one join is available, the other is null user_id | country | purpose_id 2 CA NULL 2 NULL 367 2 NG NULL 2 NULL 368 I…