Fibonacci Series using SQL - V25 - While Loop - Recursive CTE - Fibonacci Numbers using SQL

Visit my blog for full script:
https://sqlwithravimartha.blogspot.com/2021/01/blog-post.html

-- Method 1 (Using While Loop):

DECLARE @ID1 INT = 0, @ID2 INT = 1, @ID3 INT, @Counter INT = 1
PRINT 0
PRINT 1
WHILE (@Counter lessthansymbol11)
BEGIN
SET @ID3 = @ID1+@ID2
PRINT @ID3
SET @ID1 = @ID2
SET @ID2 = @ID3
SET @Counter = @Counter + 1
END

Video 24: Splitting data based on format in SQL | * https://youtu.be/9jIAV0Epixw
Video 23: Missing Sequence Number in SQL | Recursive CTE | Generate Sequence Number --* https://youtu.be/ASfEvMXnZYA
Video 22: Comma Separated values to multiple rows | string_split() , Cross apply --* https://youtu.be/cz473aUXSZQ
Video 21: XML Path in SQL - https://www.youtube.com/watch?v=UGPtK3FKUIo&list=PLgGPoIouio2B3sXJQd_pQwy6UWo68vp6j&index=26
Video 20: Count and While loop in SQL - https://www.youtube.com/watch?v=heay_7UC590&list=PLgGPoIouio2B3sXJQd_pQwy6UWo68vp6j&index=24
Video 19: Warnings SQL? | Null value is eliminated by an aggregate or other SET operation --*https://youtu.be/XjXn-QQqHN0
Video 18: Can we Update a View in SQL? --*https://youtu.be/0D_KQrMdGmw
Video 17: Sorting in SQL | Sorting Interview Questions --*https://youtu.be/lVRkp_Ern3s
Video 16: Union Vs Union All | With Examples | Prerequisites for Union and Union All | Performance Comparison --*https://youtu.be/1DRZ4P7UaqQ
Video 15: Import data from File to table in SQL Server |.txt, .csv files to table|Import Flat File|Import Data --*https://youtu.be/55JpeOxmNgM
Video 14: Find Employees With Salary Lower Than Their Department Average in SQL --*https://youtu.be/7q6TlvTIHB8
Video 13: Find Employees With Salary Lower Than Their Department Average in SQL --*https://youtu.be/2I9FRVzxa1g
Video 12: Import Tables from one Server to another Using SSMS | Import tables using SQL Query in SSMS --*https://youtu.be/MZ1UfBPoxvg
Video 11: Table Variables in SQL Server | Pound Tables | Table Variable in SQL | Table Variable in Tempdb --*https://youtu.be/dkQB9I3PgrQ
Video 10: Quick Practical onTemporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table--*https://youtu.be/QxMeM1QNveM
Video 9: Temporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table -- *https://youtu.be/3zUBwtlY1u4
Video 8: Running total & Avg in SQL | Cumulative Sum & Avg in SQL | Calculating running total & Avg in SQL -- *https://youtu.be/ACv9JNHmmPw
Video 7 Title: Length Vs DataLength Vs ColumnLength | Len() | DataLength() | Col_Length | Column length in SQL -- * https://youtu.be/3wnFJ0d9WFs
Video 6 Title: Tricky CASE Statement Interview Questions | CASE WHEN | WHEN Clause | CASE Statement in SQL -- * https://youtu.be/oVFYlK9zrpc
Video 5 Title: Delete Duplicates in SQL by retaining one Unique record | Row Duplicates | Business Key Duplicates -- * https://youtu.be/XzfPpP_VWgs
Video 4 Title: Difference between TRUNCATE, DELETE and DROP -- * https://youtu.be/DaflPqe3Q3M
Video 3 Title: Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting --* https://youtu.be/eqSThzHVbSw
Video 2 Title: Difference between Primary Key and Unique Key --*https://youtu.be/kRBVT-uDJYA
Video 1 Title: Logical Processing of SELECT Statement -- *https://youtu.be/YZB8p2Anhr4
SQL Step by Step Video 8 Title: UPDATE | DELETE | WHERE | ALTER | DROP in SQL -- *https://youtu.be/cOoV0rcYBdQ

Blog: https://sqlwithravimartha.blogspot.com/

Facebook Page:
https://www.facebook.com/SQL-With-RaviMartha-109497027391239/
https://www.facebook.com/ETL-DWH-Testing-100494175057349/