> 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