Open In App

Print different star patterns in SQL

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Share
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