I got a little question. I would like to select N rows from 5 id. I already tried this request : SELECT a.fk_produit_id, a.id, a.titre, a.prix, a.description, a.short_description, a.image_url from produits p, articles a WHERE p.id = a.fk_produit_id AND p.fk_category_id…
Is there a way to get the N iteration of an SQL query ? For example, if I want the second iteration : Backup id id_device nb_cut 11 222 853 10 5 698 9 222 589 8 5 123 7…
So I've been building an analytics tool in crypto that requires ingesting a few billion rows of data across a couple tables. Sales, Listings, NFTs, Metadata, Contract info, etc. I take that data and machine learn on it, outputting quite…
Table CREATE TABLE users ( username VARCHAR(128) PRIMARY KEY, info JSONB ); INSERT INTO users (username, info) VALUES ('Lana', '[ { "id": "first" }, { "id": "second" } ]'), ('Andy', '[ { "id": "first" }, { "id": "third" } ]');…
This is my table structure: PERSON (4.1 M rows) id : UUID notes: string ... --- ATTRIBUTES (21 M rows) id: UUID person_id: <persons id> non null name: ENUM : full_name | birthday | email | phone | photo value:…
I have 4 tables in PostgreSQL: Projects Organizations Organization_membership User CREATE TABLE IF NOT EXISTS organization( id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (), CONSTRAINT plan_id_fk FOREIGN KEY (plan_type) REFERENCES plan(plan_type) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION…
I've data like below: ID Task Time 1 X started T1 2 X ended T2 3 X started T3 [wrong entry in data] 4 X started T4 5 X ended T5 6 Y started T6 [wrong entry in data] 7…
I have the following SQL query: SELECT `NeighbourhoodName`, count(NAME) as `Number of Parks`, sum(CASE WHEN `parks`.`Advisories` = 'Y' THEN 1 ELSE 0 END) as Advisories, FROM parks GROUP BY `NeighbourhoodName`; In the second line of the code, I create a…
I have a database of polymorphic structure: a "base" type table and two "derived" types: CREATE TABLE ContactMethod( id integer PRIMARY KEY person_id integer priority integer allow_solicitation boolean FOREIGN KEY(person_id) REFERENCES People(id) ) CREATE TABLE PhoneNumbers( contact_method_id integer PRIMARY KEY…
model Comment { id Int @id @default(autoincrement()) cid String bid String author AppProfile @relation(fields: [bid], references: [bid]) comment String created DateTime @default(now()) } const results = await prisma.comment.create({ data: { cid: req.body.cid, comment: req.body.comment, bid: appProfile.bid, }, }); prisma:query INSERT…