Posted by David Portas on 10/23/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
--

• Next in forum: "owner name" cannot be omitted in sql 2005 querries?
• Prev in forum: Re: SQL Distinct Value and Order by some Field......
• Thread view: Re: SQL Distinct Value and Order by some Field......

[Reply to this message]