[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

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

• From: "Thomas B. Passin" <tpassin@h...>
• To: xml-dev@l...
• Date: Sun, 01 Jul 2001 23:06:41 -0400

[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

• Prev by Date: Re: Against the Grain: Pascal commentary about XML and databases
• Next by Date: Re: SchemaTA (was: Newbie)
• Previous by thread: Re: Against the Grain: Pascal commentary about XML and databases
• Next by thread: RE: Against the Grain: Pascal commentary about XML and databases
• Index(es):
  • Date
  • Thread