Hi,
I have a question regarding Over(Partition by
This is a short description of my data.
Customer Id Product Id CreateDate
10 A 2020-01-01
10 A 2020-01-01
10 B 2019-11-01
10 B 2019-11-01
20 A 2020-03-01
I need a query that shows the information as below;
Customer Id Product Id CreateDate SequenceNo
10 A 2020-01-01 1
10 A 2020-01-01 1
10 B 2019-11-01 2
10 B 2019-11-01 2
20 A 2020-03-01 1
How can I write a query in SQL that shows the information above?