SQL Puzzle: SQL Advance Query - Find the Square of first Ten Number

SQL Puzzle: SQL Advance Query – Find the Square of first Ten Number

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

Check the below input data and expected output to find Square of first ten number.

Expected Output:

SquareRoot

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

100

Solution:

;WITH CTE AS

(

SELECT DISTINCT

Number

,SQUARE(number) SquareRoot

FROM

MASTER..SPT_VALUES number

WHERE

Number >= 1 AND Number <= 100

)

SELECT SquareRoot FROM CTE

WHERE EXISTS

(

SELECT DISTINCT number FROM MASTER..SPT_VALUES x

WHERE x.number = CTE.SquareRoot AND x.Number >= 1 AND x.Number <= 100

)

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

Oct 3, 2017Anvesh Patel

Comments: 1

Ankush

September 14, 2018 at 11:58 am

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

SQL Puzzle: SQL Advance Query – Find the Square of first Ten Number