I have this for query for a table of a size of 2 700 000 rows in Heroku Postgres 12.16: SELECT 1 AS one FROM "users" WHERE ( external_id = 18 AND (email = '[email protected]' OR uuid = '779c7963-67b2-43ea-b19b-028759a146dc')) LIMIT…
I am trying to construct a SQL query that returns all the rows (id's) that have tag: 3 AND tag: 4 - in this case it is the single row for 564800, however I can't seem to figure out how…
I'm having a problem with multi-level whereHas because the restriction / condition of city is not being respected & the query returns all records. I know I'm performing an unnecessary nested whereHas, I know I could simplify the query, yet,…
Let say I have two table with 2 columns : Table A : Job Cost 1 100 1 200 2 100 2 150 2 50 And Table B : Job Sell 1 100 1 100 1 200 2 100 2…
I am trying to get some graph about different entries in a column in Grafana, but Grafana tries to recognize the antry as a column instead of a column value. I have the following setup: A PostgreSQL Database (v11). A…
I want to count some data in a month after a specific date. the table looks like this date user_id tx_id 2022-07-08 123 1 2022-07-08 124 2 2022-07-10 123 3 I want to count every tx_id that user_id number 123…
newbie here. There are station names in a column that have extra characters at the end. I'd like to trim them in PostgreSQL. For example, this works to remove ' (Temp)' at the end. SELECT station_name, RTRIM(station_name,' (Temp)') FROM station_data…
I am trying to build the query to remove duplicate records and retain the latest in postgres. Input : Object_Name,Id,name,insert_date,update_date a,NULL,NULL,2023-08-28, a,NULL,NULL,2023-08-29, b,test,test1,,2023-08-29 a,NULL,NULL,2023-08-30, Output :Need to delete duplicate rows where object name is same and Id and name is…
Trying to select earliest order_date for each customer_id. Using following query SELECT customer_id, order_date FROM Delivery GROUP BY customer_id HAVING MIN(order_date) = order_date But those customer_id with more than one order_date rows are not showing in the result. For example…
I have one table and data in it. Below is the table +----+-------+------+---------+-------------+-----------+ | Id | p_name| grade| promoted| created_on | review_by | +----+-------+------+---------+-------------+-----------+ | 1 | Abc | A | Yes | 2023-Jun-14 | AK | | 1 |…