Postgres Pro
Downloads
Home   >   mailing lists

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. - Mailing list pgsql-sql

From nikhil raj
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
Msg-id CAG1ps1zWGROewXyq3O6-z4JF=KGJR1D=WBAR0GSRoqUbShTGQw@mail.gmail.com
Whole thread Raw
In response to 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  (nikhil raj <nikhilraj474@gmail.com>)
List pgsql-sql
Tree view
Hi All,

Need help in rotation of data in Postgres.

There is a table called crew_details

enter image description here

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

>

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

pgsql-sql by date:

Previous
From: nikhil raj
Date:
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
Next
From: Steve Midgley
Date:
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