I want to add a new column called FullNameReverseOrder to a table called NameTable where the info for the FullName is in FirstName LastName order and the FullNameReverseOrder will hold the LastName FirstName order. this is a table you can…
I have table files Also, I have more that 100 tables where I use relation/foreign key as file_id How can I get all files with non-existing relations (it means that file not attached to any table)?
This is my first post here so please accept my apologies in advance if anything is out of place. I have table "Users", for each user there is a statement about whether he participates in promotions "IsParticipates", this is one…
db.inventory.aggregate( [ { $lookup: { from: "order", localField: "_id", foreignField: "item_id", as: "inventory_docs" } } ] ) The $lookup is joining based on the item_id field, which is indexed. If 100,000 documents pass through this $lookup, it increased the query…
I'm trying to add even more key : value data to existing json data. I get data from postgres with a query to the field and get a dictionary. After that, I simply add an additional key-value pair to the…
I have an Attendance record having fields employee code, status, attendance_date. I want to fetch those employee record who are on leave continuously for 11 days using Sql query The condition here is if employee attendance status is continuously leave…
I have a large query with the below WHERE clause that I'm hoping may be written in a cleaner / possible more efficient way. Each combination is specific and needs to be accounted for. EDIT Per the first comment i…
My system consists of Database (Timescale Db) and table telemetry_aggregations .Net Worker nodes (1...n) Every couple minutes, telemetry_aggregations table gets updated with couple hundreds of new rows. How system should work Every node periodically requests new batch of data (SQL…
I have 2 tables with flex one-to-many relationship, meaning the parent side may not have any child: Parent_table id dim1 quantity price 1 "abc" 1 1.00 child_table: id parent_id 1 1 2 1 The parent query is very straight forward:…
Context I have this table: Time Metric A Metric B Value A A A 1 A A B 2 A A C 1 B A A 1 B A B 2 B A C 1 I want to get the…