| |
[2010-07-20] Sorting by Count(*)
The other day, I was working on a fairly database-centric project, when I came across a problem I had never come across before. It seemed like such a simple task that I could not fathom why I could not write the query to get what I wanted. What I needed to do was to choose only the entries in a table which appeared a certain number of times.
[2010-07-08] How to Dupe Duplicate Rows in Three Easy Steps
Repetitive information goes against good database design, and thus is reason enough to find and remove duplicate values. However, when utilizing an UNIQUE key or other types of indexes, duplications actually break or prevent statements from executing properly.
|
|
