| Below query will help us to apply while loop in sql. This is like for loop in other languages.
declare @Counter as int
declare @MaxOscars as int
set @Counter=1
set @MaxOscars=1
WHILE @Counter <= @MaxOscars
BEGIN
---Sql Statement
End
SET @Counter += 1
END
| | |