>Hi all!
>
>I have a table with 3 fields
>
>order store pallet
>22 1 234
>22 1 235
>22 1 236
>23 1 240
>23 1 241
>
>How to use a SELECT so i know that order 22 have 3 records
>and order 23 have 2 records??
>
>Best regards
>
>Per Simmersholm
SELECT order, CNT(*) as NumLines;
FROM MyTable ;
GROUP BY order