Thank you so much sir for making videos on daily after watching all your videos im feeling that im improving everyday
@AnandKumar-dc2bfАй бұрын
You are making awesome vidoes hope u get much more viewerships...
@MeanLifeStudiesАй бұрын
I really wish and Thank you so much for you support.
@namangarg7023Күн бұрын
Just one request pls use small cte names and aliases it would be easy for beginners all the best..🙂
@harishsingh_424Ай бұрын
Awesome 👍 Request you to please make a detailed video on the stored procedure. I have searched the entire youtube but not getting helpful
@MeanLifeStudiesАй бұрын
Thank you. I will do it soon.
@kailashpatro5768Ай бұрын
hi sir what i did first i create one table min(date), max(date) after that i join the table with sales_info then after i by using lead() function i solved the solution with cte as ( select customername , min(date) as first_date, max(date) as last_date from sales_info group by customername ) select *, ((lead(SalesAmount,1) over(partition by c.customerName order by c.first_date)) - s.SalesAmount )*100/s.SalesAmount as prev_amount from cte c inner join sales_info s on s.date in (c.first_date,c.last_date)