MySQL column aliases
In the process of refactoring some MySQL queries in some PHP code, I came across some interesting syntax for field aliases in the existing code and poked around a bit…
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. Quite honestly the hardest part about this type of Microsoft…
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 back your data up before running an UPDATE Query —…
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: back up your table before running this type of query!…
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 tables in a one-to-many relationship in an “order system”-type database.…