Select with grouping in range Select with grouping in range sqlite sqlite

Select with grouping in range


Try this:

SELECT Cast(((A / 10) * 10 + 1) as varchar(100)) + '-' + Cast(((A / 10) * 10 + 10) as varchar(100)) AS 'Range A',Count(*) as 'Count B' FROM TableAGROUP BY A / 10