SQL Puzzle: Calculate the Power of Three

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input data and expected output to get the power of three within first 100 numbers.

Expected Output:

PowerOfThree

------------

Create a table with first 100 numbers:

CREATE TABLE tbl_Numbers

(

ID INT

);

DECLARE @Counter AS INT = 1;

BEGIN

WHILE @Counter < 100 BEGIN

INSERT INTO tbl_Numbers VALUES (@Counter);

SET @Counter = @Counter + 1;

END;

Solution:

SELECT ID AS PowerOfThree

FROM tbl_Numbers

WHERE LOG(ID, 3) = ROUND( LOG(ID, 3), 0);

Please try the different solution for this puzzle and share it via comment...

May 12, 2018Anvesh Patel

Comments: 2

Ankush

September 12, 2018 at 11:08 am

Select power(3, power) from (
Select 0 as power from dual Union
Select Rownum r
From dual
Connect By Rownum <= 100) foo

Dpan

April 15, 2019 at 8:57 am

Declare @powerOf int
set @powerOf=1
while (@powerOf<100)
begin
set @powerOf=@powerOf * 3;
print @powerOf
end