Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


SQL PUZZLE | How to calculate GCF of two numbers?

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

Reference – https://www.mathsisfun.com/greatest-common-factor.html

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 Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ 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/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Advertisements