I have two PostgreSQL tables, 'A' and 'B', with the following structures: Table 'A': id: primary key with auto-increment res_id: foreign key referencing table 'B' description: table description last_update: date type Table 'B': id: integer primary key with auto-increment description:…
I've got a set of accounting data that I need to query using MySQL, but I'm having trouble figuring out how to convert the ending balance of a month into the beginning balance for the next month. Here's an example:…
I want to write a SELECT query in MySQL to find words with only and only specific characters in database. For example if data is : id word --------- 1 a 2 b 3 aa 4 ab 5 aaa 6…
My dbfiddle I have a table that stores user counts every 5 minutes for multiple devices. Each device has it's own row per timestamp. As I show in my fiddle, I created a query to sum all of the rows…
Trying to figure out how to convert multiple rows of data to a single row of KeyValue array Setup: using MS SQL SERVER 2017 raw data: Select s.id, s.FkId, s.name ,s.value from tbl s where FkId = 1024180 id |…
MySQL / MariaDB structure: Person | id | |----| | 1 | | 2 | | 3 | Car | person_id | car | |-----------|-------| | 1 | Ford | | 2 | Mazda | | 3 | Ford |…
I want to save LineString like the below in Postgresql {"type": "FeatureCollection", "features": [{"type": "Feature", "properties": {"style": {"color": "#19f3e7", "weight": 2}}, "geometry": {"type": "LineString", "coordinates": [[50.998085021972656, 35.83528137207031, 1000.0, 1682083948.0], [50.99810028076172, 35.83527374267578, 1000.0, 1682083948.0], [50.998023986816406, 35.835289001464844, 1000.0, 1682083948.0]]}}]} [50.998085021972656, 35.83528137207031, 1682083948.0]…
I have two tables. 'users' table: id name book1 book2 book3 1 Brian name1 name2 name3 2 John name3 name1 name2 'library' table: id book_names position 1 name1 2 2 name2 3 3 name3 1 What I want is: The…
i have a problem with sql request. I have 3 tables. table_1 id name 1 aaa 2 bbb 3 ccc 4 ddd table_2 id name 1 zzz 2 yyy 3 xxx 4 www And third table for many to many…
I have a problem that involves the WHERE clause of my query: ... WHERE distinct_policy.policy_created_date_time between '2023-03-01' and '2023-03-11' The column "policy_created_date_time" is a timestamp without time zone. I want to select only ten days (first March - tenth March),…