Can't you count how many rows there are and then sort by the variable of interest, limiting output to half the count, all within SQL?
Roman Sent from my T-Mobile 4G LTE Device -------- Original message -------- From: Ronald Gombach <ron...@gombach.com> Date: 11/21/16 7:12 AM (GMT-05:00) To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] SQLite binary with Math Functions for OS-X? Is there a pre-c binary of SQLIte available for down load that includes a math library. I particularly need the “median” function. If not, can someone point me to instructions on compilation command line to include the math library (OS-X). Thanks for any info you can share. Ron Gombach ron...@gombach.com <mailto:ron...@gombach.com> The Gombach Group Morrisville, PA 215-295-6555 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users