I'm starting learn Go and SQL. I tryed to make initial migration using golang-migrate in my go project. Database is postgresql This is migration file: CREATE TABLE users ( id serial not null unique, name varchar(255) not null, username varchar(255)…
I have 2 tables arh and ar .I need to delete records from arh table for each accountMappingId where actionRequestId is <= maximum actionRequestId for the operation 'RESTORE' on the equivalent mappingId in ar table. The records should be deleted…
My existing SQL looks like the below, it will generate only the total_pending_req count. SELECT count(table1.employee_code) as total_requests, table1.employee_code as emp_code FROM table1 WHERE employee_status = 'PENDING' GROUP BY emp_code UNION ALL SELECT count(table2.employee_code) as total_requests, table2.employee_code as emp_code FROM…
I have this query in Postgres: Select "Charges"."saleAmount", "Charges"."buyAmount", "Operations"."id" From "Charges" Left Join "Operations" On "Operations"."id" = "Charges"."operationsId" Order By "Operations"."id" saleAmount buyAmount id 200 NULL id1 300 500 id2 0 100 id3 I need to transform it: Add…
when i am trying to create postgres database with bash terminal on windows 11, im using below commands; createdb 'test' or createdb -U postgres 'test' and nothing happens. i added the bin folder to paths in "environment variables" of windows.…
Hello I am kinda new to sql. Just wanna know if this is possible via sql: Table: (Multiple values are in just 1 cell.) COLUMN 1 COLUMN 2 "2023-01-01", "2023-01-02", "2023-01-03" "User A, User B, User C" Needed Output: COLUMN…
As title. I write some SQL code like below : SELECT p.id, json_agg( json_build_object('id', sp.id) ) AS subProducts FROM product p LEFT JOIN sub_product sp ON sp.product_id = p.id GROUP BY p.id as will be observed within the demo but…
I have a table as follows with below three columns Date table_name count 1/6/2023 table1 5161454381 1/6/2023 table2 286759521 1/6/2023 table3 43756630 1/6/2023 table4 27032087 1/6/2023 table5 44189394 1/6/2023 table6 63475022 1/5/2023 table1 5362300063 1/5/2023 table2 289459360 1/5/2023 table3 59042261…
I am building a search functionality and need help with a postgres query. My use case is - When a string is an input, what is the best (optimized) way in postgres to get all records where each words in…
Suppose I have a table A with columns: (id, item, price). It has records like id item price 1 banana 1 2 banana 1 3 apple 2 I want to calculate the average price after deduplication based on the item…