Change Order of Week Names to Show Current Data First

Question

Change Order of Week Names to Show Current Data First

clbishop

Newbie

Points: 3
More actions
April 5, 2016 at 9:55 am

#309646

Hello. Pardon me, I'm new to both this forum and SQL.
I need assistance with code that will allow me to change the return order of week names. Currently, the return as the following:
Weeks 9,8,7,6,5,4,3,2,14,13,12,11,10,1 ... and so on
I need the data to return in current order, such as:
Weeks 14,13,12,11,10,9,8,7,6,5,4,3,2,1 ... and so on
How might I resolve this?
Thank you.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246977 More actions · Answer 1

clbishop (4/5/2016)
Hello. Pardon me, I'm new to both this forum and SQL.
I need assistance with code that will allow me to change the return order of week names. Currently, the return as the following:
Weeks 9,8,7,6,5,4,3,2,14,13,12,11,10,1 ... and so on
I need the data to return in current order, such as:
Weeks 14,13,12,11,10,9,8,7,6,5,4,3,2,1 ... and so on
How might I resolve this?
Thank you.

Select Week

from table

order by Week DESC

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

shaneoneillis SSCommitted Points: 1750 More actions · Answer 2

Phil Parkin (4/5/2016)
clbishop (4/5/2016)
Hello. Pardon me, I'm new to both this forum and SQL.
I need assistance with code that will allow me to change the return order of week names. Currently, the return as the following:
Weeks 9,8,7,6,5,4,3,2,14,13,12,11,10,1 ... and so on
I need the data to return in current order, such as:
Weeks 14,13,12,11,10,9,8,7,6,5,4,3,2,1 ... and so on
How might I resolve this?
Thank you.
Select Week
from table
order by Week DESC

The Weeks column seems to be a string in his example Phil 🙁 ...

Cast them as INT first to get around this...hopefully there is nothing else in there to break this

Select Week

from table

order by CAST(Week as INT) DESC

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

what is the data type of "week"?

maybe if "week" is varchar then

ORDER BY cast(week as int) DESC

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day