esProc Desktop's Blog
Tag

Databases

#databases

More content

Read more stories on Hashnode

Articles with this tag

#117 — Simple Grouping

Dec 13, 20241 min read

Problem description & analysis: Here below is a data table: Task: We want to group the data by Class and calculate the average score of each subject...

#117 — Simple Grouping

#116 — Concatenate Members with the Same Ranking

Dec 12, 20241 min read

Problem description & analysis: Here below is a data table: Task: Rank the students by math score and concatenate the names of students having the...

#116 — Concatenate Members with the Same Ranking

#111 — Sort in Group

Dec 5, 20241 min read

Problem description & analysis: Here below is a data table: Task: Sort the data (in ascending order) by Class and (in descending order) by...

#111 — Sort in Group

#101 - Deduplication of Row-Based Data - by Whole Row

Nov 21, 20241 min read

Problem description & analysis: There is a data table: Task: Find out the whole-row data that are not duplicate and the first duplicate whole-row...

#101 - Deduplication of Row-Based Data - by Whole Row

#100 — Deduplication of Row-Based Data — by Key Column

Nov 20, 20241 min read

Problem description & analysis: There is a data table: Task: Find out the data that are not duplicates and the first duplicate data in the Name...

#100 — Deduplication of Row-Based Data — by Key Column

#99 — Deduplication of Simple Data

Nov 19, 20241 min read

Problem description & analysis: There is a data table: Task: We want to duplicate the data. Solution: Use SPL XLL and enter the following...

#99 — Deduplication of Simple Data