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 ...

I've got a SQL Query in Access 2003 that returns a series of values. I'd like to dump ALL of the records except the very top one. I thought initially it'd be easiest to "rank" them and then create a ...