I want to get the count of 'unitsold' for each Name from 3/1/2022 and 4/1/2022. For example Name 'a' required to count its units sold from 3rd to 8th day. SQL query: select Name, sum(unitsold) over (partion by Name order…
I have two tables, Table_One & Table_two. I have written an SQL statement that Joins Table_One to the latest record of Table_two. What I want is to include the read_reciept(count) as a column in the result. Table_One: ID Name 1…
I tried to add a foreign key, but it doesn't work create database if not exists lukas; use lukas; show databases; create table if not exists buch( lel int primary key, zeit date ); create table if not exists preis(…
I have a column name as Item_code which have the values like 'RAM-1','RAM-2', 'RAM-2'....'RAM-12'. I have to write procedure in postgreSQL which find maximum value from this column. CREATE OR REPLACE FUNCTION public.get_last_itemcode( item text) RETURNS text LANGUAGE 'plpgsql' COST…
I have a need to get the max number of records from a table and concatenate that number at the end of the field name, starting at 1 and ending at the max number of records: field1 cnt Car 4…
I have a table where we have two columns in question: Emp_ID and Status Current Table: Emp_ID Status 12 Permanent 13 Casual 14 Temp 14 Casual 15 Permanent 15 Casual 16 Casual 16 Casual 17 Casual 17 Permanent 18 Causal…
items = Items.objects.filter(active=True) price_list = [] for item in items: price = Price.objects.filter(item_id = item.id).last() price_list.append(price) Price model can have multiple entry for single item, I have to pick last element. How can we optimize above query to avoid use…
I have data in my postgres table like this. I want to get a result like this. I tried nested query like this. I only did rows where column1 is having multiple values in column2. For example, C3, c4 have…
This does not solve my problem SQL Join to the latest record I want to join tables in such a way that it fetches only the latest record from one of the tables using MySQL and also count the read_reciept…
I am trying to subtract two dates in postgres sql. example 2022-10-31 and 2022-11-1. So I did below approach. select (date_column1 - date_column_2) as date_diff from table; My expected output is 2 days (data type of column is interval). But…