π¨ Reminder π¨Join us for CrateDB Office Hours tomorrow!
Chat with our engineers about #cursors in #CrateDB, correlated #subqueries, and new aggregation #functions (MIN_BY and MAX_BY) π§π»βπ» Got another topic you'd like to discuss? Leave a comment below!
π March 15th
π 5 PM CET/ 11 AM ET
π No registration required! Join via Zoom.
Check out our community post for the Zoom link π https://community.crate.io/t/cratedb-office-hours-wednesday-march-15-2023/1399/1
Catch up on related topics by reading our recent #blogposts here π https://crate.io/blog
#cursors #cratedb #subqueries #functions #blogposts
Donβt miss the opportunity to talk to CrateDB engineers at our next #CrateDB Office Hours π
For our next session, we prepared to talk about #cursors in CrateDB, correlated #subqueries, and new #aggregation #functions (MIN_BY and MAX_BY) π€ Curious about other CrateDB topics? Leave your suggestions in the comments!
π March 15th
π 5 PM CET/ 11 AM ET
π No need for registration! Join via Zoom
Learn more and get your zoom link in our CrateDB #Community post π
https://community.crate.io/t/cratedb-office-hours-wednesday-march-15-2023/1399
#cratedb #cursors #subqueries #aggregation #functions #community
I aquΓ tenim el poder dels #subqueries de #Postgresql:
select count(server) as servers from fediverse where last_checked_at-first_checked_at in (select MAX(last_checked_at - first_checked_at) from fediverse);
Una sola lΓnia de codi, un sol query i llestos.