How to get previous date and current date records

Asked May 16 '23 at 03:33

Active May 16 '23 at 03:43

Viewed 33 times

How to get based on MRLnum last and previous date records

MRLNum	CreatedOn	ReviseCode	RequiredQty
SAN-000027-001	2/27/2023	0	100
SAN-000027-001	2/28/2023	1	30
SAN-000027-001	3/29/2023	1	30
SAN-000028-001	3/21/2023	1	30
SAN-000028-001	3/23/2023	1	30
SAN-000028-001	3/29/2023	1	30
SAN-000028-001	3/30/2023	1	30

result like this:

MRLNum	CreatedOn	ReviseCode	RequiredQty
SAN-000027-001	2/28/2023	1	30
SAN-000027-001	3/29/2023	1	30
SAN-000028-001	3/29/2023	1	30
SAN-000028-001	3/30/2023	1	30

edited May 16 '23 at 03:43

Dale K

asked May 16 '23 at 03:33

wfxasb

1

We'd love to see what you have tried. – Dale K May 16 '23 at 03:34
1

What do you mean exactly by `"previous date and current date"`? The expected result does not matches with your description of `previous` and `current` date – Squirrel May 16 '23 at 03:36
in the table based on mrlnum last date and previous date. – wfxasb May 16 '23 at 03:37
Please show your desired results... And whats `rowInt`? – Dale K May 16 '23 at 03:38
use [row_number](https://learn.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver16) to achieve what you want. Do give it a go – Squirrel May 16 '23 at 03:40

0 Answers0