Printing Star Patterns using SQL - Part 26
HTML-код
- Опубликовано: 18 сен 2024
- Visit my blog for full script:
sqlwithravimar...
Video 26: Printing Star Patterns using SQL - Part 26 | * • Printing Star Patterns...
Video 25: Fibonacci Series Using SQL - Part 25 | * • Fibonacci Series using...
Video 24: Splitting data based on format in SQL | * • Splitting data based o...
Video 23: Missing Sequence Number in SQL | Recursive CTE | Generate Sequence Number --* • Missing Sequence Numbe...
Video 22: Comma Separated values to multiple rows | string_split() , Cross apply --* • Comma Separated values...
Video 21: XML Path in SQL - • Comma Separated values...
Video 20: Count and While loop in SQL - • Count Function in SQL ...
Video 19: Warnings SQL? | Null value is eliminated by an aggregate or other SET operation --* • Warning in SQL | Null ...
Video 18: Can we Update a View in SQL? --* • Can we Update a View i...
Video 17: Sorting in SQL | Sorting Interview Questions --* • Sorting in SQL | ORDER...
Video 16: Union Vs Union All | With Examples | Prerequisites for Union and Union All | Performance Comparison --* • Union Vs Union All | W...
Video 15: Import data from File to table in SQL Server |.txt, .csv files to table|Import Flat File|Import Data --* • Import data from File ...
Video 14: Find Employees With Salary Lower Than Their Department Average in SQL --* • Find Employees Whose S...
Video 13: Find Employees With Salary Lower Than Their Department Average in SQL --* • Find Employees With Sa...
Video 12: Import Tables from one Server to another Using SSMS | Import tables using SQL Query in SSMS --* • Import Tables from one...
Video 11: Table Variables in SQL Server | Pound Tables | Table Variable in SQL | Table Variable in Tempdb --* • Table Variables in SQL...
Video 10: Quick Practical onTemporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table--* • Quick Practical on Tem...
Video 9: Temporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table -- * • Temporary tables in SQ...
Video 8: Running total & Avg in SQL | Cumulative Sum & Avg in SQL | Calculating running total & Avg in SQL -- * • Running total & Avg in...
Video 7 Title: Length Vs DataLength Vs ColumnLength | Len() | DataLength() | Col_Length | Column length in SQL -- * • Length Vs DataLength V...
Video 6 Title: Tricky CASE Statement Interview Questions | CASE WHEN | WHEN Clause | CASE Statement in SQL -- * • Tricky CASE Statement ...
Video 5 Title: Delete Duplicates in SQL by retaining one Unique record | Row Duplicates | Business Key Duplicates -- * • Delete Duplicates in S...
Video 4 Title: Difference between TRUNCATE, DELETE and DROP -- * • Difference between TRU...
Video 3 Title: Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting --* • Sorting in SQL | Order...
Video 2 Title: Difference between Primary Key and Unique Key --* • Difference between Pri...
Video 1 Title: Logical Processing of SELECT Statement -- * • Logical Processing of ...
SQL Step by Step Video 8 Title: UPDATE | DELETE | WHERE | ALTER | DROP in SQL -- * • UPDATE | DELETE | WHER...
Blog: sqlwithravimar...
Facebook Page:
/ sql-with-ravimartha-10...
/ etl-dwh-testing-100494...
good video, thank you so much
You are welcome!
ty man u dont know how this helps me
thank you
Hi my name is Dinesh I have a question for relevant this topic how to print star pattern in my sql bcz it's not working in myself workbench can you please post this question
Not exact solution though but below code would give you the clue to solve these start patterns
SET @maxlen := 5;
WITH RECURSIVE
cte AS (
SELECT @maxlen num
UNION ALL
SELECT num - 1 FROM cte WHERE num > 1
)
SELECT REPEAT('*', num)
FROM cte
This code is not working in MySQL I'm getting syntax error anyone can explain?
But working in MySQL server
can you ping me the error message which you are getting?
kindly provide solution of mysql also, Thanks!
Below code would give clue to solve these star patterns
SET @maxlen := 5;
WITH RECURSIVE
cte AS (
SELECT @maxlen num
UNION ALL
SELECT num - 1 FROM cte WHERE num > 1
)
SELECT REPEAT('*', num)
FROM cte