When you want to merge multiple rows from a table into one field separated by a specific character using MySQL.
By utilizing the existing GROUP_CONCAT function with MySQL, you can easily group multiple rows together into a single field result.
Category: Database
-
Calculate a Running Total in SQL Server
Let’s imagine a scenario where I have a table that contains a numeric value. When I select the data from this table I want to add another column that contains the running total of all the previous numeric values added together. By leveraging SQL servers two functions: SUM() and OVER() this can be accomplished.
-
Entity Framework Core Database First (with examples)
Entity Framework Core is a popular object relational mapping software on the market. The .NET Core provides an efficient method for writing queries in C# while EF Core is responsible for transforming it into a similar SQL language and executing it on a connected database.
(more…) -
SQL Server Clustered Indexes vs. Nonclustered indexes
In this article, we’ll discuss about the difference between clustered indexes and nonclustered indexes with SQL Server.
The clustered index is an internal data structure that stores all the records in a table. It is also called the primary key because each record has its unique identifier stored in the first column of the row. By the end of this article hopefully I will have answered the question of the difference of the clustered index vs nonclustered index with sql server.
-
SQL Server Convert String to Date with examples
There are two common functions to convert a string to a date in sql server: the CONVERT() function and CAST() function.