Grouping Items of this same Category
-
Good day friends! Please I need help in this issue. I have a database made up of
Name Section Day of Duty John U. Fishery Monday Andrew S. HR Tuesday Chow C. Mgr Monday Bian H. Coord. Tuesday Hui Zhao APC WednesdayMy request is that; if I retrieved the records from database, they should be grouped by Day of Duty and display in this format:Name Section Day of Duty John U. HR Monday Chow C. Mgr Monday Andrew S. HR Tuesday Bian H. Coord. Tuesday Hui Zhao APC WednesdayI tried using Group By SQL statement but to didn't work and I don't know the right keywords to use while searching on google though I have tried. Please can this be achieved? Help please! Am using ASP.Net (VB.Net) -
Good day friends! Please I need help in this issue. I have a database made up of
Name Section Day of Duty John U. Fishery Monday Andrew S. HR Tuesday Chow C. Mgr Monday Bian H. Coord. Tuesday Hui Zhao APC WednesdayMy request is that; if I retrieved the records from database, they should be grouped by Day of Duty and display in this format:Name Section Day of Duty John U. HR Monday Chow C. Mgr Monday Andrew S. HR Tuesday Bian H. Coord. Tuesday Hui Zhao APC WednesdayI tried using Group By SQL statement but to didn't work and I don't know the right keywords to use while searching on google though I have tried. Please can this be achieved? Help please! Am using ASP.Net (VB.Net) -
Try SQL ORDER BY Keyword[^].
This is also possible with the linq by using the same order by query.
-
This is also possible with the linq by using the same order by query.