OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

[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
> in any SQL query logic that I know of (although a good DBA can pull off
> 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


Tom P