```SELECT ROW NUMBER OVER PARTITION BY version FROM os versi osquery #core

```SELECT ROW_NUMBER() OVER (PARTITION BY version)...

Chris Broome

09/13/2019, 5:50 PM

Copy code

SELECT ROW_NUMBER() OVER (PARTITION BY version) FROM os_version;

works in the osquery sqlite shell, so I’m guessing that means window functions are enabled