[ic] query sql question?

Topastro topomorto at email.it
Tue Sep 14 10:46:37 EDT 2004


thank... I didn't remember "desc"

Rene Hertell ha scritto:

>>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é
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users at icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users
>  
>

-- 
Topomorto... per una sentenza sbagliata   :'(
Topomorto dice NO alla pena di morte... soprattutto la sua 



More information about the interchange-users mailing list