In GORM documentation there is an example how to use LIKE conditions: // LIKE db.Where("name LIKE ?", "%jin%").Find(&users) // SELECT * FROM users WHERE name LIKE '%jin%'; The problem that I have with this approach is that if jin is…
Basically, I want to remove the whitespace that exists after numbers Input: medication_title CLORIDRATO DE VENLAFAXINA 75 MG VIIBRYD 40 MG KTRIZ UNO 0.6 U/G Ouput: medication_title medication_title2 CLORIDRATO DE VENLAFAXINA 75 MG CLORIDRATO DE VENLAFAXINA 75MG VIIBRYD 40 MG…
I have a table: client_id Date Resolution 1 2022-10-15 CANCELLED 2 2022-10-25 CANCELLED 3 2022-10-16 CANCELLED 3 2022-10-17 REJECTED 4 2022-10-08 CANCELLED 4 2022-10-20 APPROVED 5 2022-10-03 CANCELLED 5 2022-10-04 APPROVED Desired results: client_id 1 2 4 I need to…
First time asking a question in stackoverflow, and sorry if my english is bad, but hope someone can help me: So, a project is using: ruby '2.4.2' # Bundle edge Rails instead: gem 'rails', github: 'rails/rails' gem 'rails', '5.2.0' #…
I have tables like this: Table_0 CustomerID Trans_date C001 01-sep-22 C001 04-sep-22 C001 14-sep-22 C002 03-sep-22 C002 01-sep-22 Table_1 CustomerID Trans_date C002 18-sep-22 C002 20-sep-22 C003 02-sep-22 C003 28-sep-22 Table_2 CustomerID Trans_date C004 08-sep-22 C004 18-sep-22 C004 20-sep-22 C005 18-sep-22…
I have this SQL query: SELECT users.id, users.name, users.avatar, MAX(messages.created_at) max_created_at, MAX(messages.body) FILTER (WHERE messages.created_at = MAX(messages.created_at)) last_message, CASE WHEN(COUNT(messages.is_read) FILTER (WHERE is_read = false AND messages.from_id != 14) = 0) THEN true ELSE false END is_read, COUNT(messages.is_read) FILTER (WHERE…
My purpose is to gain averages of values stored in child-tables depending on each parent-table. In my case, I want to gain averages of satisfaction stored in the Evaluation model (child) depending on each Professor model (parent). models.py class Professor(models.Model):…
I have 3 tables: companies (id, name) union_products (id, name) products (id, company_id, union_product_id, price_per_one_product) I need to get all companies which have products with union_product_id in (1,2) and total price of products (per company) is less than 100. What…
Let's assume I have four fields A,B,C,D I need SQL query to show results only when two or more fields are not null
Let's say I have the following tables: create table user ( id int ); create table transaction ( user_id int, date timestamp, amount int ); I have an array of 100 users (result from another query). I'd like to get…