Hello,
I'm having problems using the replace and then being able to group by the results.
E.G.
This does not produce unique records based on myversion created with the AS clause.
If I change the Order By to include myversion, it works in mySQL but errors on MS SQL saying invalid column name?
How do I replace some content from a column and group to produce unique records?
Cheers,
1DMF.
"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Google Rank Extractor -> PERL v1.5 beta (FusionCharts)
I'm having problems using the replace and then being able to group by the results.
E.G.
Code:
SELECT REPLACE(REPLACE(version,' (Global)',''),' (Local)','') AS myversion, COUNT(1) AS Cnt FROM grank WHERE ((position > 0 AND position <= 100) AND refdate BETWEEN '2009/10/27' AND '2009/11/02') GROUP BY version ORDER BY Min(id) ASC
This does not produce unique records based on myversion created with the AS clause.
If I change the Order By to include myversion, it works in mySQL but errors on MS SQL saying invalid column name?
How do I replace some content from a column and group to produce unique records?
Cheers,
1DMF.
"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Google Rank Extractor -> PERL v1.5 beta (FusionCharts)