Hey all, I could use a little help in improving a SQL Query. I have some tables that store poll/trivia questions and answers for a website. There is only going to be one poll displayed per day ...
i have 2 tables, one is a list of vehicles, the other is a regularly updated(2 minutes) list of their coordinates, with a timestamp of the coordinate, and a reference ID. i am having a bit of trouble ...
A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...