> What would the window-function query be?
Note: For anyone stumbling upon this thread, below code is not supported in
SQLite natively.
SELECT F1, F2
FROM (
SELECT F2, F1, Rank()
OVER (PARTITION BY F2
ORDER BY F1 ) AS Rank
FROM T
) WHERE Rank <= 10
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
