Select API with NestJS #141. Getting distinct records with Prisma and PostgreSQL

from Marcin Wanago Blog - JavaScript, both frontend and backend 5 months ago

Let's say we have the following model created with Prisma.
Marcin Wanago Blog - JavaScript, both frontend and backendhttps://wanago.io/2024/01/15/api-nestjs-distinct-postgresql-prisma/

The DISTINCT ON keyword is similar to DISTINCT, but allows us to retain other columns from the row.
Marcin Wanago Blog - JavaScript, both frontend and backendhttps://wanago.io/2024/01/15/api-nestjs-distinct-postgresql-prisma/

Read at Marcin Wanago Blog - JavaScript, both frontend and backend

#postgresql #prisma #query-results #duplicate-rows

[

]

[

...

]

Select API with NestJS #141. Getting distinct records with Prisma and PostgreSQLSelect API with NestJS #141. Getting distinct records with Prisma and PostgreSQL Briefly

Select API with NestJS #141. Getting distinct records with Prisma and PostgreSQL
Select API with NestJS #141. Getting distinct records with Prisma and PostgreSQL
Briefly