I have the table like: start_dt end_dt ID Index 2023-01-01 2023-03-08 A i 2023-05-08 2023-06-18 A i+1 2023-12-09 2024-02-02 A i+2 2024-12-01 2025-01-05 A i+3 2023-02-01 2023-03-07 B j 2023-06-08 2023-07-18 B j+1 2024-12-09 2024-02-02 B j+2 I need to…
Please help me with raw postgresql query: given models.py: from django.db import models class Menu(models.Model): name = models.CharField(max_length=255) menu_url = models.CharField(max_length=255) def __str__(self): return self.name class MenuEntry(models.Model): menu = models.ForeignKey("menu", null=True, blank=True, on_delete=models.CASCADE) parent = models.ForeignKey("menuentry", null=True, blank=True, on_delete=models.CASCADE) text…
Coming from SQL Server where I know that the MERGE command needs some extra care like locking hints to be an atomic operation, I now take my fist steps with PostgreSQL. I now came to a point where I would…
Suppose the following: create schema bv; create table bv.user(id bigint primary key); create table bv.user_photo ( id bigint primary key, url varchar(255) not null, user_id bigint references bv.user(id) ); insert into bv.user values (100), (101); insert into bv.user_photo values (1,…
I have a SQL query like this: select age_group, sum(member_count), sum(discharge_count) from newtable group by age_group order by age_group; It is returns these results: age_group member_count discharge_count 18-64 Years 150 245 6-17 Years 185 325 65 and Above Years 125…
I have database in PostgreSQL and I currently have a query that I found from Stackoverflow to get the list of tables with it's current row count. WITH tbl AS (SELECT table_schema, TABLE_NAME FROM information_schema.tables WHERE TABLE_NAME not like 'pg_%'…
I have the following PostgreSQL table: create table companies ( id bigserial primary key, created_at timestamp(6), name varchar(200), status varchar(200) ); I would like to split the result by month and to pass the months by param. How I can…
For example if I have a 'customers' database similar to: state customer Alabama Adam Alabama Aaron Oklahoma Randy California Sam California Darren And I want to grab 10 random customers from each state, how would I go about accomplishing this?…
I have DOB stored in dB as 2 digit value (IE: 98,99,05...), how I can compare it to today's date to get age? Tried different variations, even converted today's date to 2 digit but I cannot compare it... TIMESTAMPDIFF(year, d.dob,…
I am looking to number the rows of my output with four 1’s, then four 2’s etc etc regardless of the value in the rows. My data is sorted by week so I am basically trying to group the weeks…