[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Against the Grain: Pascal commentary about XML and databases
- From: "Thomas B. Passin" <email@example.com>
- To: firstname.lastname@example.org
- Date: Sun, 01 Jul 2001 23:06:41 -0400
> > "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