Radim Motycka

Radim Motycka

  • NA
  • 3
  • 1.3k

select distinct

Feb 23 2013 2:23 AM
Hi,

Please could you advice?

Is posible to do distinct select from these? I am idiot thx a lot.

ltr_BarCode ltr_DbtrN smx_ID
C5117051 7048622 25747
C5117407 7016883 25585
C5119627 7025342 25489
C5119627 7025342 25490

But I need it in this way not only one or two columns. Please note that last column is not unique.

SELECT TempSent.*
FROM TempSent 
where ltr_BarCode
 IN (SELECT DISTINCT ltr_BarCode from  TempSent)

Answers (2)