Re: Against the Grain: Pascal commentary about XML and databases

["Thomas B. Passin" <tpassin@home.com>]

[Jeff Lowery]

> > "gee could you roll
> > up the sales by category and month?"
>
> Yeah, but if he asked you to roll up the TOP FIVE sales, you'd be stuck:
> it's not a relational query, it's a relative query. And you can't perform
it
> in any SQL query logic that I know of (although a good DBA can pull off
some
> damned-near miracles).
>

Bah! Pfui! (I've been reading Nero Wolfe stories again, don't mind me).
Create a view to get the top five, then use that view to roll them up in a
query.

Cheers,

Tom P