[ic] ASP like Perl
Steffen Dettmer
interchange-users@interchange.redhat.com
Wed Dec 5 05:03:28 2001
* 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 :)
oki,
Steffen
--
Dieses Schreiben wurde maschinell erstellt,
es trägt daher weder Unterschrift noch Siegel.