Home / Questions / 126617
Accepted
J. Rodríguez
Asked: 2020-12-23 06:44:27 +0800 CST 2020-12-23 06:44:27 +0800 CST

How to adjust the order of the days of the week

  • 772

I need to sort this data to display it in a DataGridViewC#.

In SQL ServerI have the following table:

Día  Descripción
----------------
1   Domingo
2   Lunes
3   Martes
4   Miércoles
5   Jueves
6   Viernes
7   Sábado

But in the query I can't sort the day with ascor desc, because it won't be sorted correctly:

select * from dias_semana order by dia asc
select * from dias_semana order by dia desc

How can I modify the query to display it sorted like this?

Día  Descripción
----------------
2   Lunes
3   Martes
4   Miércoles
5   Jueves
6   Viernes
7   Sábado
1   Domingo

Note: The table contains much more data, but the field diais the only one for which I can set an order in the statement select.

sql

1 Answers

  1. Best Answer

    You can use a little trick with the modulo operator ( %) :

    select *
  from dias_semanas
 order by (dia + 5) % 7

    Demo

    • 5