Return specific columns from DB

This is the place to post technical queries about SQL Yoga

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, trevordevore

Return specific columns from DB

Postby nrprioleau » Wed Oct 12, 2016 2:00 pm

What is the syntax using sqlyoga for the following:

Code: Select all
SELECT year(sales_salesDate) as yr from sales
GROUP BY yr


Or can I build my own query such as the above and execute within the SQL Yoga framework?
nrprioleau
 
Posts: 24
Joined: Mon May 09, 2016 10:53 am

Re: Return specific columns from DB [RESOLVED]

Postby nrprioleau » Wed Oct 12, 2016 8:35 pm

I have found my solution.
nrprioleau
 
Posts: 24
Joined: Mon May 09, 2016 10:53 am


Return to SQL Yoga

Who is online

Users browsing this forum: No registered users and 0 guests