[ic] query sql question?

Rene Hertell interchange-users at hertell.com
Tue Sep 14 08:00:11 EDT 2004


> Hi to everybody,
> just a question:
> I need to find the greatest card number from all my cards.
> I have a table called card (sku, name ecc....)

<snip>

Use limit for limiting the query-result to one..

select sku
from products
order by sku desc
limit 1

René




More information about the interchange-users mailing list