This code sniippet is used to fetch the consecutive records from the table which has a difference of more than 500.
Previously, we used to prefer cursors. I have tried an alternative for the cursor (CTE).
Thanks and Regards,
Venkatesan Prabu .J
This code sniippet is used to fetch the consecutive records from the table which has a difference of more than 500.
Previously, we used to prefer cursors. I have tried an alternative for the cursor (CTE).
Thanks and Regards,
Venkatesan Prabu .J
create table Venkat_sample(name varchar(100),amount int) insert into Venkat_sample values('deepak',2000) insert into Venkat_sample values('vijeta',2200) insert into Venkat_sample values('shruti',4000) insert into Venkat_sample values('prink',5000) select * from Venkat_sample with cte as ( select row_number() over (order by amount) as Row_Id ,name, amount from Venkat_sample ) select name as emp_name,amount from ( select (a.amount-b.amount) as diff,a.[Name],a.amount from cte a inner join cte b on a.Row_Id=b.Row_Id+1 )t where diff>500