Count Consecutive Days 1

[IAMINFO]

Hello everyone I am learning sql and I am not sure how to
proceed.

I need to get a list of names that have a balance of 5.00 or less for the last 30 consecutive days.

Please help or guide me to an example
I might study. Thank you very much for taking the time


select First_Name,Last_Name,balance
from imbalance
where balance <= 5.00

 

[markros]

Take a look at this thread183-1575641

declare @StartDate datetime

set @StartDate = dateadd(day,-30, datediff(day,0,getdate()))

select First_Name,Last_Name,balancefrom imbalancewhere balance <= 5.00 and DateField >=@StartDate