SQL: How to select the particular distinct value of a column

See more:

SQL-Server-2005

SQL-Server

Hello,


i need the values of the other fields corresponding to distinct registrationno ,but the distict property should not be applied to the other fields

Here is my code:

select  'Active' as VS, registrationno, gps_datetime,speed,location  from gpsdata_previous   
where registrationno in(select registrationno from  vehicle_superuser where superuserid=@uid) AND(GPS_DATETIME BETWEEN @fromdate AND @todate)   
and   speed <>0 

union   
  
select 'Inactive' as VS,registrationno,gps_datetime,speed,location  from gpsdata_previous   
  
where registrationno in(select registrationno from  vehicle_superuser where superuserid=@uid)  AND(GPS_DATETIME BETWEEN @fromdate AND @todate)  
and  speed=0 

Please help me out.

Thanks.