esProc Desktop's Blog
Tag

learn coding

#learn-coding

More content

Read more stories on Hashnode

Articles with this tag

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

Feb 21, 20252 min read

Problem description & analysis: An invoice table in the SQL Server database has one amount for each project, and each project in the project table has...

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

#141 — Generate Continuous Arrays — Concatenate Results into a String

Feb 8, 20251 min read

Problem description & analysis: The values in columns A and B are natural numbers, representing the start and end points of the array...

#141 — Generate Continuous Arrays — Concatenate Results into a String

#140 — Generate Continuous Arrays

Feb 7, 20251 min read

Problem description & analysis: There is a column of serial numbers (No), as shown in the figure below: Task: Now we want to use the two numbers in...

#140 — Generate Continuous Arrays

#137 — Re-group or Sort When Filling Grouped Data into Columns

Jan 26, 20251 min read

Problem description & analysis: There is a data table. In this table, the products with the same name may have multiple colors. Task: Convert the...

#137 — Re-group or Sort When Filling Grouped Data into Columns

#127 — Concatenate Data Within Groups into Text

Jan 8, 20251 min read

Problem description & analysis: Here below is a data table: Task: Group the data by Dept, and concatenate the names within the same group into the...

#127 — Concatenate Data Within Groups into Text

#113 — Ranking of Row-Based Data

Dec 9, 20241 min read

Problem description & analysis: Here below is a data table: Task: Calculate the ranking of students by TotalScore (in descending order) and fill the...

#113 — Ranking of Row-Based Data