public inbox for [email protected]  

help / color / mirror / Atom feed

From: nikhil raj <[email protected]>
To: [email protected]
Subject: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range
Date: Sun, 26 Feb 2023 02:05:22 +0530
Message-ID: <CAG1ps1wWWGS1bai_N5n-aJzTQ7Efv9WR37OPAydnT1MBqbrZBQ@mail.gmail.com> (raw)
In-Reply-To: <CAG1ps1z_-s1yZM3fGghR07s2VcGN5xWPHYqWNBEX-0ujV7m_Dg@mail.gmail.com>
References: <CAG1ps1z_-s1yZM3fGghR07s2VcGN5xWPHYqWNBEX-0ujV7m_Dg@mail.gmail.com>

Hi All,

Need help in rotation of data in *Postgres*.

There is a table called crew_details

[image: enter image description here] <https://i.stack.imgur.com/cTarQ.png;

There is a requirement to rotate the crew members for in weekly or on the
every 7th day and continue for rest 6days the same order of for the given
date range un till it reach end date . and the expected output should be
like this below

[image: >] <https://i.stack.imgur.com/hjasI.png;

Please can any one help me in in the rotation in *postgres SQL*

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range
  In-Reply-To: <CAG1ps1wWWGS1bai_N5n-aJzTQ7Efv9WR37OPAydnT1MBqbrZBQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox