No dear thats what not i looking for.I have to eliminate repeating binder no.Max concept not applicable for following data.CREATE TABLE [REV_BINDERS](

[OFFICE_ID] [int] NOT NULL,

[BINDER_ID] [int] NOT NULL,

[BINDER_NO] [varchar](7) NULL,

);

go

INSERT INTO [REV_BINDERS]

([OFFICE_ID],[BINDER_ID],[BINDER_NO])

select 2105110 , 1,0101 union all

select 2105110,2,0102union all

select 2105110,3,0103union all

select 2105110,4,0104union all

select 2105110,5,0108union all

select 2105110,6,0105union all

select 2101110,261,0101union all

select 2101110,262,0102union all

select 2101110,263,0103union all

select 2101110,264,0104union all

select 2101110,265,0106union all

select 2101110,266,0105

For above data required output is.

2105110,5,0108

2101110,265,0106

Only those binder no which are not repeating.