Some tips when using GROUP BY in SQL Server
Using ROLLUPThe GROUP UP clause is used to group the results of aggregate functions according to a specified column. However, the GROUP BY clause doesn’t perform aggregate operations on multiple levels of a hierarchy. In that case, you can use the ROLL UP to calculate the subtotals and grand totals for a set of columns.
See example below:
12345SELECT R.nameNode AS Register, COUNT(*) AS Mark_NumbersFROM C_Node R JOIN C_ClientMark CM ON CM.idNode = R.idNodeWHERE R.isActive = 1 AND CM.isActive = 1G ...
Write My First Game: MineSweeper
This is my first game developed by C# WinForm platform. The initial object is to practice my C# level. So the first game jump into my mind is “MineSweeper”. It is enough simple and interesting. In this post I will list my conception and some difficult point during my development.
To see my MineSweeper project in github.
See also the rule for mineSweeper
Class Conception
In this application three main objects are used in models:
Class Game presents one game, every time when we create or restar ...
Hexo Tutorial
Welcome to Hexo! This is your very first post. Check documentation for more info. If you get any problems when using Hexo, you can find the answer in troubleshooting or you can ask me on GitHub.
WorkflowCreate a new post1$ hexo new "post title"
That will create a markdown file named by your title, and an image folder which has the same name in sub directory source\_posts\
Write blogPut your categories and tags in your markdown file.Write the article after < !-- more -- >.To inser ...
