I am using PostgreSQL If I want to get customer.first_name, customer.last_name or any other column in addition to customer_id and sum(total), I am getting error as shown below: select i.customer_id, cu.first_name, cu.last_name, sum(total) as amount from invoice i join customer…
I was using Postgres 14 and PGAdmin4 6.7 for a long while and everything was fine. This is on Windows 11. Yesterday I tried upgrading to Postgres 15 and PGAdmin4 7.6 and that's where it fell apart! Postgres 15 is…
I need to write a Query that gives me January 31's rolling 3 day average of total transaction amount processed per day I used the query below, but I'm having problem to retrieve information, because it keeps giving this error:…
I have a PostgreSQL scenario where I have a database table with packet captures (each packet has a timestamp and a length), and I want to calculate the “current” bandwidth in use. I’m currently using a 100 ms sliding window, like…
PostgreSQL version: 15 I have dynamic tables with dynamic columns and I need to calculate some abstract property length. If column is array then I need to use array_length function, if column is string then length. I tried to use…
I have this table CREATE TABLE IF NOT EXISTS public.campaign_result ( id integer NOT NULL DEFAULT nextval('campaign_result_id_seq'::regclass), state result_state NOT NULL DEFAULT 'processing'::result_state, data json NOT NULL, response json, act result_action NOT NULL DEFAULT 'none'::result_action, message character varying COLLATE pg_catalog."default",…
I have the following PostgreSQL query: SELECT extract(YEAR from date), AVG(amount) FROM transactions GROUP BY extract(YEAR from date) ORDER BY extract(YEAR from date) How can I refactor the query so that extract(YEAR from date) does not have to be repeated…
I've have started building a banking project using Java, a Spring Boot application, and a PostgreSQL database. I want to generate a random 8 or 10-digit account number each time I create a new account. What's the best way to…
I have an SQL query: select * from sval where fid = 994 and val = 'XLON'; that returns id fid val 100 994 's' 102 994 'd' 103 994 'd' 104 994 'd' 110 994 's' 140 994 's'…
In the following table create table employee (emp_id integer, emp_name varchar(50), dept_id integer); insert into employee values (1,'bob william',1); insert into employee values (2,'scott tiger',1); insert into employee values (3,'amit gupta',1); insert into employee values (4,'vijay sinha',1); insert into employee…