Running SQL jobs to trim the database periodically ... I was only able to make a query time out once, with the following query: SELECT * from commons."twitter-firehose" ORDER by "twitter-firehose ...

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?

Hi all - is there an easy statement that would let me query a database for records from the first of the month untill the last day of the month?<BR><BR>In my test sql, I have been using this:<BR ...

With Steampipe, a better saying might be: everything’s a SQL table. The official tagline ... Need help getting a complex query right? We do, too, sometimes.