MySQL column aliases
In the process of refactoring some MySQL queries in some PHP code, I came across some interesting syntax for field…
Creating TOTALS in Access queries
In Grade 12 one of the most advanced skills you will learn is how to aggregate data using a query.…
An UPDATE query in Microsoft Access
To actually change the values in your table you can run an UPDATE Query against the table. You should always…
A DELETE query in Microsoft Access
OK so now you must tread lightly! DELETE queries are destructive — there is no “undo”! The Golden Rule is:…
Complex SQL query using SUM and GROUP BY
I got this question as part of a skills evaluation test. It requires a query to aggregate data from 2…