I want to select rows which have a difference of more than 1 in OU_DEA
Hello everyone, I want to select rows which have a difference of more than 1 in OU_DEAL_ID column. Eg: There are 4 values, 202513,202515,202996, 202999. So I want to group 202513,202515 (put row tag as 1) and group 202996, 202999 (put row tag as 2) using lag operation, I am getting the DIFF for 202515, but not sure of how I can get the first row(202513). For this I can assign row_number ordering OU_DEAL_ID, but not sure of how I can do that in
Rajanikant HawaldarPosted Jun 8, 2021, 11:29 AM
Chandu KPosted Jun 7, 2021, 12:31 PM
Rajanikant HawaldarPosted Jun 6, 2021, 10:16 AM
Chandu KPosted Jun 5, 2021, 11:41 AM
Rajanikant HawaldarPosted Jun 5, 2021, 10:10 AM