SQL Distinct Value and Order by some Field......
From: krishnan <krishnanthangaraj_at_gmail.com>
Date: 4 Jan 2006 04:42:14 -0800
Message-ID: <1136378534.929942.88740_at_f14g2000cwb.googlegroups.com>
Dear all,
Date: 4 Jan 2006 04:42:14 -0800
Message-ID: <1136378534.929942.88740_at_f14g2000cwb.googlegroups.com>
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