Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have values in a table 2016-Q1,2016-Q2,2016-Q3,2016-Q4 and its associated counts.I would like to convert this as YYYY to get the counts for total year.Could anybody suggest the way to achive it.I have tried min string but not successful
Try this:
left(fieldname, 4) as fieldName
Try this:
left(fieldname, 4) as fieldName