This SQL feature allows you to query within a result set, creatively limit your result set, or correlate your results with an otherwise unrelated query in a single call to the database.