Database

CREATE TABLE #tmpData
(
	id INT IDENTITY(1,1),
	custname VARCHAR(MAX)
)

INSERT INTO #tmpData
SELECT m.Customername 
FROM mytable1 m 
GROUP BY m.Customername,m.phonenumber,m.city,m.street HAVING COUNT(m.Customername)>1

DECLARE @i AS INT
DECLARE @query AS nvarCHAR(MAX)

SET @i=0
SET @query = 'select * from mytable1 where customername in ('

WHILE(@i<(SELECT COUNT(*) FROM #tmpData))
BEGIN
	SET @i=@i+1
	SET @query=@query+(SELECT char(39)+custname + char(39) FROM #tmpData WHERE id=@i)+',' 
	
END
SET @query=SUBSTRING(@query,1,LEN(@query)-1)
SET @query=@query+')'

EXEC(  @query)
DROP TABLE #tmpData

select a.id,a.Customername , a.phonenumber, a.city, a.street     
from mytable1 a
inner join 
(select Customername , phonenumber, city, street
from mytable1
group by customername,phonenumber,city,street
having count(*) > 1) b  
on a.Customername = b.Customername

select * from myTable where customername in (
select customername
from myTable 
group by customername,phonenum,city,street
having(count(customername)>1 and count(phonenum)>1 and count(city)>1 and count(street)>1))

id	customername	phonenum	city	street
19	jon	555	NK	st.5
37	jon	555	NK	st.5

Alter YourTableName
check (intCol > 0 and intCol < 100)

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