Database

order by case when priority = 0 then 9999 else sequence end

Priority    PriorityOrder
-------------------------
0           5
1           1
2           2
3           3
4           4

declare @t table(docvalue varchar(50),priority int)
insert into @t select 'aaa',0 union all select 'xxx', 1 union all select 'bbb', 3 union all
select 'ccc',0 union all select 'aaa',2

select docvalue,priority  from @t where priority <> 0 group by priority,docvalue
union all
select * from @t where priority = 0

select distinct * from @t where priority <> 0 group by priority,docvalue
union 
select * from @t where priority = 0

docvalue	priority
xxx	1
aaa	2
bbb	3
aaa	0
ccc	0

<<thashif>> wrote:

I neva asked u 2 work or complete the task for me

<code>SELECT</code> MyTable.Column1 , S.Column2,S.Column3, S.Column4
<code>FROM</code> MyTable , (
<code>Select</code> MyTable.T2 , MyTable.T3, MyTable.T4
<code>From</code> MyTable
<code>Group By</code> MyTable.T2 , MyTable.T3, MyTable.T4
<code>Having</code> ( Count(Sheet1.T2)>1 and Count(Sheet1.T3)>1 and Count(Sheet1.T4)>1 )
) as S
<code>Where</code> MyTable.T2=S.T2 and MyTable.T3=S.T3 and MyTable.T4=S.T4

SELECT 
(SELECT top 1 m2.Clmn1 FROM mytable m2 WHERE m2.Clmn2= m.Clmn2) Clmn1 ,--by this subquery you get first value of clmn1 column 
clmn2,clmn3,clmn7
FROM mytable m
GROUP BY m.clmn2,m.clmn3,m.clm7
HAVING 
COUNT (col2) > 0 AND
COUNT (col3) > 0 AND
COUNT (col7) > 0