Open In App
Related Articles

Print different star patterns in SQL

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Report issue
Report
Let’s see how we can print the pattern of various type using SQL. Syntax :

Declare @variable_name DATATYPE     -- first declare all the
                                    -- variables with datatype
                                    -- like (int)

select @variable = WITH_ANY_VALUE   -- select the variable and 
                                    -- initialize with value

while CONDITION                     -- condition like @variable > 0 

begin                               -- begin

print replicate('*', @variable)     -- replicate insert the *
                                    -- character in variable times

set increment/decrement             -- in increment/decrement
                                    -- @variable= @variable+1
END                                 -- end while loop


First Pattern :
DECLARE @var int               -- Declare
SELECT @var = 5                -- Initialization
WHILE @var > 0                 -- condition
BEGIN                          -- Begin
PRINT replicate('* ', @var)    -- Print
SET @var = @var - 1            -- decrement
END                            -- END

                    
Output :
* * * * *
* * * * 
* * * 
* * 
*

Second Pattern :
DECLARE @var int                  -- Declare 
SELECT @var = 1                   -- initialization 
WHILE @var <= 5                   -- Condition
BEGIN                             -- Begin
PRINT replicate('* ', @var)       -- Print
SET @var = @var + 1               -- Set
END                               -- end

                    
Output :
*
* *
* * *
* * * *
* * * * *

Third Pattern :
DECLARE @var int, @x int                 -- declare two variable
SELECT @var = 4,@x = 1                   -- initialization
WHILE @x <=5                             -- condition
BEGIN
PRINT space(@var) + replicate('*', @x)   -- here space for 
                                         -- create spaces 
SET @var = @var - 1                      -- set
set @x = @x + 1                          -- set
END                                      -- End

                    
Output :
    *
   **
  ***
 ****
*****

Fourth Pattern :
DECLARE @var int, @x int                 -- declare two variable
SELECT @var = 0,@x = 5                   -- initialization
WHILE @x > 0                             -- condition
BEGIN
PRINT space(@var) + replicate('*', @x)   -- here space for
                                         -- create spaces 
SET @var = @var + 1                      -- set
set @x = @x - 1                          -- set
END                                      -- End

                    
Output :
*****
 ****
  ***
   **
    *


Last Updated : 21 Mar, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads