Complex Database query--Help Please |
I am tgrying to find the median value in a table.
This works: Code: SELECT round(AVG(middle_values),0) AS 'median' FROM ( I am not sure how to write the query buidler. Thanks. Bill Hogsett
You don't need to use the query builder for everything, just run your query:
https://www.codeigniter.com/user_guide/d...eries.html It will also be faster, as it dosen't need to be run through some PHP functions on the way. (11-19-2018, 02:32 PM)jreklund Wrote: You don't need to use the query builder for everything, just run your query: Thanks, this is what I needed and had missed. |
Welcome Guest, Not a member yet? Register Sign In |