[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: Against the Grain: Pascal commentary about XML and databases
- From: Al Snell <alaric@alaric-snell.com>
- To: Jeff Lowery <jlowery@scenicsoft.com>
- 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