In my PostgreSQL DB, I have a table with a field of the type text which contains a string like this: |ABX1-001|ABX1-002|ABX1-004|ABX1-005| I would like to count the items inside the text field current_ids. This is the structure of the…
I have 2 tables and when i join them on ID column I get very absurd count. Is it a bug or something wrong from my end? Env: Aurora MySQL (5.7.12) cpu = 8 vcpu RAM = 64GB RAM Table1:…
I have the following table: CREATE TABLE IF NOT EXISTS test ( date DATE, value INT ); INSERT INTO test VALUES ( '2022-01-11', NULL), -- Tues ( '2022-01-10', 5), -- Mon ( '2022-01-09', NULL), -- Sun ( '2022-01-08', 6), --…
I have a table like this: CREATE TABLE test( id INT AUTO_INCREMENT PRIMARY KEY, server_id VARCHAR(15) NOT NULL, secret_number INT NOT NULL, processing_status VARCHAR(15) DEFAULT 'UNPROCESSED', ts TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ); I want to get the SUM(secret_number) of…
Need to retrieve a column from a group-by query, and this column is not part of the group-by clause. I have a table that receives telemetries from equipments: COLUMNS: transmission_tag varchar -- this is kind of a transmission package identifier…
sample code SELECT b.title, i.barcode FROM biblio b JOIN items i ON b.biblionumber= i.biblionumber Join biblioitems bi ON i.biblionumber=bi.biblionumber where i.barcode IN (4088,6183,6191) above SQL given results as below, how do I get results in IN (4088,6183,6191) as entered order
The query outputs lines with more than one comma, but I only need ONE comma and ONE semicolon SELECT * FROM table WHERE history_coord is NULL OR history_coord LIKE '%,%' AND history_coord LIKE '%;%' How do I change the request?…
We have a table "url_rewrite" in our Magento 2 store and we need to copy a lot of values inside this table. We have a column "store_id", that contains values from 1 until 4. Another column with "target_path" and the…
I am really struggling with producing some code create 'level1 question' & 'level2 question' columns. The logic to populate the columns is: 'L1' when level = 1 & type = group then question 'L2' when level = 2 & type…
I have a small query to run in my controller, it works fine in MySQL Workbench SELECT subprocess_id, MAX(CASE WHEN step_no = '1' THEN s_name END) AS first_step, MAX(CASE WHEN step_no = '2' THEN s_name END) AS second_step, MAX(CASE WHEN…