Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: "krishnan" <krishnanthangaraj@gmail.com>
Newsgroups: comp.databases.theory
Subject: SQL Distinct Value and Order by some Field......
Date: 4 Jan 2006 04:42:14 -0800
Organization: http://groups.google.com
Lines: 20
Message-ID: <1136378534.929942.88740@f14g2000cwb.googlegroups.com>
NNTP-Posting-Host: 61.247.240.225
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1136378539 20098 127.0.0.1 (4 Jan 2006 12:42:19 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 4 Jan 2006 12:42:19 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=61.247.240.225;
   posting-account=JsxPrQ0AAAAIVLAV7etOMz0aseQaKgdK
Xref: dp-news.maxwell.syr.edu comp.databases.theory:35363

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