[ic] ASP like Perl

[Jeff Fearn]

>* Korey Gozman wrote on Fri, Nov 30, 2001 at 15:12 -0800:
> > I want to pull all the fields that match the criteria
> > but it only displays the last entry in tha table.
> > any suggestions?
>
>For postgres, you could order reverse and give a limit 1, i.e.:
>
>select sku from products where ... order by ... limit 1
>
>But in standard-SQL it's not really possible I think, usually SQL
>is deterministic :)

Amazing how something can trigger a long buried memory :}

If your sku's are automatic, this should work:
select sku from products where ... and sku = max(sku)

syntax may be a little off as I have not tested it :}

Jeff.

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp