how to print star using sql

my sql printing pattern sql 4 years, 8 months ago

DECLARE @var int SELECT @var = 5 WHILE @var >0 BEGIN PRINT replicate('* ', @var) SET @var = @var - 1 END ** In simlar way you can print different patterns ** or you can query the atterns in the below way also SET @number = 0; SELECT REPEAT('* ', @number := @number+1) FROM information_schema.tables LIMIT 20;

940

output:
*
* *
* * *
* * * *
* * * * *
* * * * * *

sonia shaik

Posted By

Please Login to Comment Here


                            ALTER TABLE table_name SET SCHEMA new_sc

sql postgresql

kishore_kumar


                            Drop table Table_name;

sql mysql

sonia shaik


                            Simple Case:
case search-expression
    WHEN expression [, expression [ ...

sql postgres oracle

sonia shaik


                            COALESCE(value [, ...])
The COALESCE function accepts an unlimit
It returns the first argument that is no

sql postgres oracle

sonia shaik


                            SELECT
   concat_ws (column1,column2) AS new_co
FROM

sql concat_ws

Reshma


                            -- New versions of postgres
-- adding as primary key

sql postgres postgresql

kishore_kumar


                            sudo -i -u postgres

psql

dump postgresql sql

Reshma

how to print star using sql

0 Comments

Blog

SiteMap

Social

KoderPlace