I have these tables: CREATE TABLE poster ( poster_id SERIAL NOT NULL PRIMARY KEY, country VARCHAR ( 50 ) NOT NULL ); CREATE TABLE batch ( batch_id SERIAL NOT NULL PRIMARY KEY, price VARCHAR ( 50 ) NOT NULL );…
I have 3 tables 1 table with all the information which I want to extract to two tables [flat file] name / team / town [team table] teamID/ team / town [person table] personID/ name / teamID now I can…
PostgreSQL version: 14.10 I'm facing an issue with a PostgreSQL SQL query that aims to retrieve records from the partner_online_time table for the current month. The query is as follows: SELECT * FROM partner_online_time WHERE TRIM(month) = TO_CHAR(CURRENT_DATE, 'Month'); Despite…
I have a list of items. Original items were set a property, but there was a bug in the app where child rows didn't inherit the property. Here is what I've tried to fix it: UPDATE queue_items SET property_value =…
I have a query that filters the emails of people who "have a quantity" bigger than the median over all quantities found in the table: SELECT AVG(quantity) AS avg_quantity, email FROM table GROUP BY email HAVING AVG(quantity) > (SELECT PERCENTILE_DISC(0.5)…
I created test function with the proper characteristic DETERMINISTIC as shown below because it always produces the same result 3 according to the doc: CREATE FUNCTION test() RETURNS INT DETERMINISTIC -- Here RETURN 3; And, I also created test function…
For the last few days, I have been working to write a MySQL query to extract a result. Basically, I have to join two tables log and conditions table based on any column of the log table from the trigger_param_value…
Edited to clarify and simplify I have the following query select Signups.user_id, Count(timeoutTable.user_id) as timeoutCount, Count(confirmedTable.user_id) as confirmedCount from Signups left join ( select * from Confirmations where action = 'timeout' ) as timeoutTable on signups.user_id = timeoutTable.user_id left join…
I am using MariaDB and I am trying to create a query that updates the boolean column is_popular of my photos table, called Pics. To find out which photos are "popular", I pick the top 10 from the entire table.…
I have a big table (~30M rows), it usually run fast( 5-6ms per request). Sometimes one request take a lot of time (something like 60sec). Here the table structure : CREATE TABLE table ( id int(11) NOT NULL, A int(11)…