Kysely

Join the Kysely server to ask questions!

Join

Kysely

Join the community to ask questions about Kysely and get answers from other members.

Join

Channels

help

query-showcase

announcements

CCoffee11

9/26/2023

Select count?

Can't find any docs regarding this can someone send me the docs for this? Thank you in advance.

Bbun

8/30/2023

how to sort `db.updateTable` returning values?

``` await db .updateTable("users") .where("id", "in", ({ selectFrom }) => selectFrom("users")...

Ddecho

7/2/2023

Prediction league leaderboard

Hey, hope I'm not becoming annoying, but I thought I'd share another query I made, perhaps someone can find it useful. This is a leaderboard for a prediction league. It's using 2 CTEs. In the first one we count occurences where the user predicted the correct result, outcome or first scorer of the match. In the second one we sum and multiply these occurrences by score factor, to distribute points with the following score system: - 1 point for guessing the correct outcome...

Ddecho

6/30/2023

CTE with exists() and case()

Hey guys, just wrote this one and I thought I'd share. ```sql WITH "ongoing" AS (...

IIgal

4/9/2023

sale representative performance for Q3 2015

please share your solutions or discuss the solutions in the comments. Kysely feedback and suggestions for enhancement are also welcome....

IIgal

4/8/2023

olympic gold medals

query https://user-images.githubusercontent.com/103982094/211247985-7d15da7b-820f-4615-810b-bd317f3acc13.png please share your solutions or discuss the solutions in the comments. Kysely feedback and suggestions for enhancement are also welcome....

IIgal

4/6/2023

duplicate job listings

query https://user-images.githubusercontent.com/103982094/211246010-ea3cf036-1973-4a69-b2da-57ecc51737a3.png please share your solutions or discuss the solutions in the comments. Kysely feedback and suggestions for enhancement are also welcome....

IIgal

4/5/2023

stock trade

query https://user-images.githubusercontent.com/103982094/228803165-415ff305-d8d7-49e2-ba93-1359bf69c74f.png please share your solutions or discuss the solutions in the comments. Kysely feedback and suggestions for enhancement are also welcome....