Posted by Danny on 08/26/05 16:35

There is no concept in SQL Server for top entry or first entry. Only
explict ordering based on the data. For first entry you wound need an
additional field describing the order in which the entries were made.

"wirelessguy" <law_40@hotmail.com> wrote in message
news:1125034364.621426.10840@g47g2000cwa.googlegroups.com...
> thanks for the response. the "top most" entry refers to the first entry
> for each customer in the table.
>
> based on the informaiton provided, i would have to use the first
> suggestion. However, does the min() funtction work with non numeric
> values? my picture ID's are text.
>

[Back to original message]