Blogs about: Sql Weaknesses
Featured Blog
Problems with the SQL operator Average
What is the average of this set of values? 4, 8, 6 The average is 6, the operation is (4+8+6) / 3. If we use the SQL operator AVG() with that set of values the result is the same six, unless at least … more →
Database Theory in Practice
Problems with the SQL operator Average
Oswaldo F. Domejean wrote 5 months ago: What is the average of this set of values? 4, 8, 6 The average is 6, the operation is (4+8+6) / 3. I … more →
Domain (Data Type) and null
Oswaldo F. Domejean wrote 5 months ago: E. F. Codd (The father of the Relational Model) defined a tree valued logic that has True, False and … more →
In the case of NOT IN (null)
Oswaldo F. Domejean wrote 5 months ago: Take a look at the example: http://dbtips.wordpress.com/2009/04/26/a-more-complex-sql-weakness-with- … more →
Some notes about null
Oswaldo F. Domejean wrote 6 months ago: Take a look at the examples: http://dbtips.wordpress.com/2009/04/26/a-simple-sql-weakness-with-the-i … more →
Some SQL weaknesses explained in a video clip
Oswaldo F. Domejean wrote 6 months ago: In the following video clip from youtube.com I explain a couple of the weaknnesses in a graphical wa … more →
A simple SQL weakness with the Intersect operation
Oswaldo F. Domejean wrote 7 months ago: … more →
A more complex SQL weakness with the conditions NOT IN vs. NOT EXISTS
Oswaldo F. Domejean wrote 7 months ago: (If needed see the example database) … more →
A simple SQL weaknesses with operator avg()
— 2 comments
Oswaldo F. Domejean wrote 7 months ago: … more →
