Return specific columns from DB
Posted: Wed Oct 12, 2016 2:00 pm
What is the syntax using sqlyoga for the following:
Or can I build my own query such as the above and execute within the SQL Yoga framework?
Code: Select all
SELECT year(sales_salesDate) as yr from sales
GROUP BY yr