Posted by David Portas on 11/12/53 11:36

krishnan wrote:
> Dear all,
>
> In SQL Server 2000 , how to get distinct records sort by one
> field .
>
> Example
>
> SELECT DISTINCT A FROM tblTEST ORBER BY B
>
> Here, In Table
>
> Field 'A' contain more than one same data...
> Field 'B' contain all are different Data......
>
> I want distince in Field 'A' and order by Field 'B'..... how to get
> it.........
>
> regards
> krishnan

Please do not multi-post!
I have answered this in microsoft.public.sqlserver.programming

--
David Portas
SQL Server MVP
--

[Back to original message]