add the slice function I wrote that also works on databases

CDU-data-science-team / nottshcMethods

An internal R package formalising common transformations, visualisations, and analyses of clinical data

https://cdu-data-science-team.github.io/nottshcMethods/

Other

4 stars 3 forks source link

add the slice function I wrote that also works on databases #24

Closed milanwiedemann closed 2 years ago

milanwiedemann commented 2 years ago

currently slice from dplyr isnt supported in dbplyr (I think) I just need to figure out where this function currently is ... 🔍 🕵️ 👨‍💻

Lextuga007 commented 2 years ago

Slice doesn't translate into SQL: slice(), slice_head(), and slice_tail() are not supported since database tables have no intrinsic order. but extended slice functions can be used, see https://dbplyr.tidyverse.org/reference/dbplyr-slice.html