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 <[email protected]> Date: 11/21/16 7:12 AM (GMT-05:00) To: [email protected] 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 [email protected] <mailto:[email protected]> The Gombach Group Morrisville, PA 215-295-6555 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
