asked on
sql group on number range, not exact number
I have a column with a decimal which is a percentage .76, .24, 1.
I want to group on this column, but in .1 pt range, meaning group 0-.09, .1-.19, .2-.29.
I want to group on this column, but in .1 pt range, meaning group 0-.09, .1-.19, .2-.29.
Microsoft SQL ServerMicrosoft SQL Server 2008C#
Last Comment
Steve Wales
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
sjwales,
score is now truncated twice, which does not matter for the result, but is superfluous.
score is now truncated twice, which does not matter for the result, but is superfluous.
Oops! You're right:
Joys of copy and paste :)
Joys of copy and paste :)
convert(varchar(4), percent_grp) + ' - ' + convert(varchar(4), percent_grp + 0.09)