Hello to all, I have to design a SQL query on an Oracle 10 DB. I want to do it in an elegant way and avoid, if possible, using sub-queries and in the most portable way possible. Basically it's ...

Self taught (and poorly at that) on SQL and I ran into something I cannot figure out if it is possible. Given that I have 2 tables: Cust_Info CI Cust_Rev_Info CRI I need to query CI with a child ...

Airbnb has open sourced Airpal, the tool it built to help employees get to data they need to use. It's built on Facebook's open source Presto SQL engine.

A simple SQL query can also be used to report on the indexes directly from the database manager catalog. This might even be better, as it allows a person to build a custom report for just those tables ...

Want faster SQL queries? Here are nine best practices for writing SQL queries that work like a charm (or at least, like they should).