Order by Week Descending based on current week

how to get current week data in mysql
sql current week
how to get current week data in codeigniter
order by day of week mysql
mysql get week number of month
sql count by week
how to get weekly data in sql
week function in sql server

Is there way to order this query by week # but starting with the current week then descending order ? So if the current week # was 2 it would order by 2,1,52,51 etc...

SELECT 
    SalesPerson
  , CAST(SUM(hours) AS DECIMAL(18 , 2))
  , DATEPART(wk , DATEADD(wk , DATEDIFF(wk , 0 , OrderDate) , 0)) AS Wk#
    FROM Orders
    WHERE OrderDate >= DATEADD(month , -12 , GETDATE())
    GROUP BY DATEADD(wk , DATEDIFF(wk , 0 , OrderDate) , 0)

Thanks! E

In your example are weeks 2 and 1 from a different year than the 52 etc? You could then ORDER BY YEAR(OrderDate) DESC, DATEPART(week,OrderDate) DESC But you would have to add YEAR(OrderDate) to your GROUP BY clause.

Sorting Days where Current Date is most current |Tableau , So this would be the 1st Day of week to display, descending Thu, Wed, Tue, etc., while maintaining the like dates for trend comparison. DayOfWeek treats Sunday as the start of the week, whereas I would like it to be ordered so it appears at the end. It's just an enum, so I can't modify it. However I've read that I may be able to create a custom culture but think this is probably overkill. List<TimeBand> orderedTimeBands = timeBands.OrderBy(x => x.DayName).ToList()

Just to order by current week first and then other weeks in descending order you can try below order logic. You can add your SELECT and other logic on top of it.

ORDER BY 
CASE WHEN 
DATEPART(week,OrderDate)  - DATEPART(WEEK, GETDATE()) = 0 THEN 100 ELSE 
DATEPART(week,OrderDate) 
END DESC

MySQL WEEK() Function, and Usage. The WEEK() function returns the week number for a given date (a number from 0 to 53). Return the week number for the current system date:. This page lists all weeks in 2020. There are 53 weeks in 2020. All weeks are starting on Monday and ending on Sunday. Please note that there are multiple systems for week numbering, this is the ISO week date standard (ISO-8601), other systems use weeks starting on Sunday (US) or Saturday (Islamic). The current week ( week 09) is highlighted.

Be careful with weeks from different years with the same number…

Anyway: Since you group by weeks, you could simply ORDER BY MIN(OrderDate) DESC.

Equipment Management: Key to Equipment Reliability and , Backlog Select Work Orders Due Next Week Arrange in Descending Order of select those work orders due fIGurE 9-3 the next week based on future timing it is helpful to check schedule compliance and performance for the current week. 4. Then type the start date (the number series) into the Start number textbox, and enter 7 into Increment textbox, and 5 into the No.of digits textbox. See screenshot: 5. Click Add to finish the new sequence creation, and then select a range of cells you want to fill dates by week, and click Fill Range.

MySQL WEEKDAY() Function, Example. Return the weekday number for the current system date: SELECT WEEKDAY(CURDATE());. Try it Yourself » · ❮ MySQL Functions · COLOR PICKER. Note 1: This is the only filter on the list, so there's nothing that should be conflicting with this one. Note 2: I only have basic modify view option, modify in sharepoint designer (advanced) is disabled. filter sharepoint-fields sharepoint-views. improve this question. asked Dec 21 '16 at 0:00. 4 bronze badges.

Industry Week, PAGE 1390 Plate Bookings Increase Orders in Past Week or Two Estimated Low phosphorus melting bars are quoted at 4.00c, base Pittsburgh. For the past four weeks orders from the automotive industrv have been on a descending scale. Present demand is well diversified. indicating that stocks in the hands of users  If you set DATEFIRST to 1, then the week will start on Monday and the day-of-week number for a Thursday, say, will be 4. Then when you use the DATEPART(dw,yourDate) expression in the ORDER BY clause, Mondays will sort first because they have a dw or day-of-week value of 1. You would use DATENAME(dw,yourDate) to show the name of the day of the week.

Last one week, month, year record from date field by DATE_SUB, DATE_SUB : Getting the last one week or two month or one year records from MySQL table. We will use the MySQL function CURDATE() to get the today's date. SQL dump file generated based on date & time to test queries → INTERVAL 7 DAY) AND CURDATE() GROUP BY tag ORDER BY date DESC, RAND() ASC  The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword. SELECT column1, column2,

Comments
  • This query won't even run. What are you actually trying to achieve? Provide sample data and your expected output.