I am writing some SQL code where i have a comma separated string with 3 values. I would like to transform this string into an array and write it into the first 3 elements of a larger array. My naive…
I am facing issue in showing the data for age group by in between. Here is my query: SELECT CASE WHEN age BETWEEN 0 AND 18 OR age IS NULL THEN '0-18' WHEN age BETWEEN 19 AND 30 THEN '19-30'…
To my understanding, database can postpone writing to table files to boost IO performance. When transaction is COMMITted, data are written to the WAL files. I'm curious, how much delayed the writing to table files can be. In particular, when…
I'm trying to find an IP address that match a range of hosts (172.24.12.???), but none of the following queries are working: select * from pg_catalog.pg_stat_activity --where client_addr <> E'(?|172.24.12.)'::inet; --where client_addr <> E'(://|^)172\.24\.12\.[0-9]'::inet I'm getting two different errors. SQL…
I need to find the highest score for each game. along with the gamename, category, PlayerCode (name of player) who got the highscore, date (time) when the score was set and ofc the score itself. My tables are set up…
raw data no group date value flag 1 a 2022-10-13 old y 2 a 2022-10-15 new y 3 b 2022-01-01 old n 4 b 2022-01-03 new n step1. insert no1 raw step2. modify date value using by no2 raw and…
I am new to SQL. in my query, I need max closeprice(column-name) with date (column-name). every month of that year. I created this query: Select max(close), date from commodity where commodity ='rice' and location= 'pune' year(date) ='2022' group by month(date)…
I have a variable that I would like to pass in a joined RAW query. How can I do that ? $current_user_id = Auth::user()->id; $query = DB::table('users as u') ->selectRaw(' ROW_NUMBER() OVER (ORDER BY u.id) AS No, u.id, u.username, l.level…
So I am trying to create a View by joining 3 tables (FlavouredBeer, BeerInfo & FlavourNotes) by the beerId in 3 tables. However, I cannot select the beerId column that I think it's useful to be shown. CREATE VIEW FlavouredBeers…
My backend database is PostgreSQL I have a TypeORM object simplified to: @Entity() @Index(['name'], {unique: true} export class Foo extends BaseEntity { @PrimaryGeneratedColumn('uuid') id: string; @Column() name: string; @Column('varchar', { array: true }) bar: string[]; } I'm creating an API…