• From: Al Snell <alaric@a...>
• To: Jeff Lowery <jlowery@s...>
• Date: Mon, 02 Jul 2001 12:33:11 +0100 (BST)

On Fri, 29 Jun 2001, Jeff Lowery wrote:

> 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).

Hahah!

SELECT * FROM Sales SORT BY value DESC LIMIT 5;

...works for me...

ABS

-- 
                               Alaric B. Snell
 http://www.alaric-snell.com/  http://RFC.net/  http://www.warhead.org.uk/
   Any sufficiently advanced technology can be emulated in software

• Follow-Ups:
  • Re: Against the Grain: Pascal commentary about XML and databases
    • From: "Thomas B. Passin" <tpassin@h...>

• Prev by Date: RE: Java and XML
• Next by Date: Re: Against the Grain: Pascal commentary about XML and databases
• 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