Sfrgttk

What does F' and F" mean?

Why light coming from distant stars is not discrete?

When a candle burns, why does the top of wick glow if bottom of flame is hottest?

Okay to merge included columns on otherwise identical indexes?

Denied boarding although I have proper visa and documentation. To whom should I make a complaint?

Why do people hide their license plates in the EU?

Generate an RGB colour grid

At the end of Thor: Ragnarok why don't the Asgardians turn and head for the Bifrost as per their original plan?

Why didn't this character "real die" when they blew their stack out in Altered Carbon?

Why did the IBM 650 use bi-quinary?

Novel: non-telepath helps overthrow rule by telepaths

ListPlot join points by nearest neighbor rather than order

What would be the ideal power source for a cybernetic eye?

How do I keep my slimes from escaping their pens?

How to find out what spells would be useless to a blind NPC spellcaster?

How to call a function with default parameter through a pointer to function that is the return of another function?

Do I really need recursive chmod to restrict access to a folder?

Book where humans were engineered with genes from animal species to survive hostile planets

First console to have temporary backward compatibility

How to override model in magento2?

Can a non-EU citizen traveling with me come with me through the EU passport line?

How do pianists reach extremely loud dynamics?

How to tell that you are a giant?

How to find all the available tools in mac terminal?

Using lag function in mysql to get previous values

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I am trying to create MySQL dataset which has entries from previous study (surgical study with the first study having value of 1) as well for that userid. Each user can have multiple studies. I am trying to use Lag function to get previous study data. I am getting duplicate values for study 1 while trying to use the lag function.

WITH Complete_Data AS (

    SELECT *

    FROM Data

    GROUP BY UserId, studyno

)

SELECT *, LAG(indication_of_failure, 1)

OVER (

        PARTITION BY UserId

        ORDER BY studyno

    ) prev_study_indication_of_failure

    , 

    LAG(BCVA_State,1)

    OVER (

        PARTITION BY UserId

        ORDER BY studyno

    ) prev_study_BCVA

FROM 

    Complete_Data

    GROUP BY UserId, studyno

    ;

I am expecting nulls in prev_study_indication_of_failure and prev_study_BCVA when studyno = 1 but filled with values when studyno >=2.

Due to duplicate entries for studyno = 1, I am getting values in prev_study_indication_of_failure and prev_study_BCVA

mysql

share

asked 4 mins ago

user1048278user1048278

1

New contributor

user1048278 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I am trying to create MySQL dataset which has entries from previous study (surgical study with the first study having value of 1) as well for that userid. Each user can have multiple studies. I am trying to use Lag function to get previous study data. I am getting duplicate values for study 1 while trying to use the lag function.

WITH Complete_Data AS (

    SELECT *

    FROM Data

    GROUP BY UserId, studyno

)

SELECT *, LAG(indication_of_failure, 1)

OVER (

        PARTITION BY UserId

        ORDER BY studyno

    ) prev_study_indication_of_failure

    , 

    LAG(BCVA_State,1)

    OVER (

        PARTITION BY UserId

        ORDER BY studyno

    ) prev_study_BCVA

FROM 

    Complete_Data

    GROUP BY UserId, studyno

    ;

I am expecting nulls in prev_study_indication_of_failure and prev_study_BCVA when studyno = 1 but filled with values when studyno >=2.

Due to duplicate entries for studyno = 1, I am getting values in prev_study_indication_of_failure and prev_study_BCVA

mysql

share

asked 4 mins ago

user1048278user1048278

1

New contributor

user1048278 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I am trying to create MySQL dataset which has entries from previous study (surgical study with the first study having value of 1) as well for that userid. Each user can have multiple studies. I am trying to use Lag function to get previous study data. I am getting duplicate values for study 1 while trying to use the lag function.

WITH Complete_Data AS (

    SELECT *

    FROM Data

    GROUP BY UserId, studyno

)

SELECT *, LAG(indication_of_failure, 1)

OVER (

        PARTITION BY UserId

        ORDER BY studyno

    ) prev_study_indication_of_failure

    , 

    LAG(BCVA_State,1)

    OVER (

        PARTITION BY UserId

        ORDER BY studyno

    ) prev_study_BCVA

FROM 

    Complete_Data

    GROUP BY UserId, studyno

    ;

I am expecting nulls in prev_study_indication_of_failure and prev_study_BCVA when studyno = 1 but filled with values when studyno >=2.

Due to duplicate entries for studyno = 1, I am getting values in prev_study_indication_of_failure and prev_study_BCVA

mysql

share

asked 4 mins ago

user1048278user1048278

1

New contributor

user1048278 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

WITH Complete_Data AS (

    SELECT *

    FROM Data

    GROUP BY UserId, studyno

)

SELECT *, LAG(indication_of_failure, 1)

OVER (

        PARTITION BY UserId

        ORDER BY studyno

    ) prev_study_indication_of_failure

    , 

    LAG(BCVA_State,1)

    OVER (

        PARTITION BY UserId

        ORDER BY studyno

    ) prev_study_BCVA

FROM 

    Complete_Data

    GROUP BY UserId, studyno

    ;

share

asked 4 mins ago

user1048278user1048278

1

New contributor

user1048278 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 4 mins ago

user1048278user1048278

1

New contributor

user1048278 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 mins ago

user1048278user1048278

1

New contributor

user1048278 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 4 mins ago

user1048278user1048278

1