SQL PUZZLE | How to calculate GCF of two numbers?

Let’s first understand what is GCF and how we calculate it.

Script to calculate GCF of two numbers

 ```-- DECLARE @Num1 INT = 6 DECLARE @num2 INT = 3 DECLARE @remAfterDiv INT = -1 IF @Num1 IS NULL OR @num2 IS NULL BEGIN SELECT NULL gcf END ELSE IF @Num1 = 0 OR @Num2 = 0 BEGIN SELECT 0 gcf END ELSE BEGIN WHILE @remAfterDiv <> 0 BEGIN SET @remAfterDiv = @Num1 % @num2 SET @Num1 = @num2 SET @num2 = @remAfterDiv END SELECT @Num1 gcf END -- ```

OUTPUT of Input 6 & 3

 ```-- gcf ----------- 3 (1 row affected) -- ```

OUTPUT of 0 and 0

 ```-- gcf ----------- 0 (1 row affected) -- ```

OUTPUT of NULL & NULL input

 ```-- gcf ----------- NULL (1 row affected) -- ```

Please add a comment if you have any other or better solution in mind. I would love to learn it. We all need to learn. Thanks in advance.

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/