table i created is not showing in SSMS even after refreshing – Mysql
i saved a table in my SSMS database but its not showing even after i refresh it. any idea what should be done??
Rails conditional order by priority and status – Postgresql
I want to order my Order model by priority, so that the ones with priority: true and with status != 'delivered' are on top. The ones with priority: true and status: delivered should be in the table below with all…
SQL Select data in the last 1 minutes – Mysql
i am currently practicing my SQL skills. I wanted to get all data in the past 1 minutes. The query is SELECT * FROM menfesses WHERE created_at >= NOW() - INTERVAL 1 MINUTE; But somehow, it returns all data. I…
Cannot filter rows based on tuple conditions – Postgresql
employe_id skill_level skill_id 1550 BEGINNER 560 6540 BEGINNER 560 2354 INTERMEDIATE 560 6654 ADVANCED 560 1550 ADVANCED 780 6540 BEGINNER 780 1550 INTERMEDIATE 780 2354 INTERMEDIATE 780 1550 INTERMEDIATE 450 6540 BEGINNER 654 8888 BEGINNER 560 6654 ADVANCED 455 1550…
How to get the number of registers by month and date – Mysql
I have rows of user data. I store the createDate, which is the timestamp in milliseconds when the user registered. I want to get the total number of registrations per month. When I try to do that, I don't get…
Updating filter options in the UI, after a query is performed – Mysql
I am building a web app for a client who has ~1M rows of data in their MySQL database. The data looks approximately like this: Products +---------+-----------+---------+-------------+---------+----------+ | Id | Name | Size | Colour | 4 Other attributes |…
PostgreSQL: get latest row for each time interval
I have the following table. It is stored as a TimescaleDB hypertable. Data rate is 1 row per second. CREATE TABLE electricity_data ( "time" timestamptz NOT NULL, meter_id integer REFERENCES meters NOT NULL, import_low double precision, import_normal double precision, export_low…
Select latest ID only, if it matches criteria – Mysql
I have a MySQL table people like this: id person_id meeting_time 1 21 123456 2 21 123457 3 21 123456 4 22 123470 5 21 0 6 21 123472 I need to get 1 row for each person_id, but only,…
how can I make result of ARRAY_AGG() function json parsable – Postgresql
I have a query that selects the rows from joined table as an array using ARRAY_AGG() function. select entity_number, ARRAY_AGG('{"property_id":"'||property_id||'","value":"'||value||'"}') entity_properties from entities join entity_properties on entities.id = entity_properties.entity_id where entities.id in ( select entity_id from entity_properties where value =…
Aggregate jsonb map with string array as value in postgresql
I have postgresql table with a jsonb column containing maps with strings as keys and string arrays as values. I want to aggregate all the maps into a single jsonb map. There should be no duplicate values in string array.…