Database

koolprasad2003 wrote:

means if the column contains 1,2,3 and i copy the same column in it then it will be 1,2,3,1,2,3

update table1<br />
set col1 = col1 + ',' + col1

ID      itemPrice <br />
-----------------------<br />
1    |   10<br />
2    |   10<br />
3    |   11<br />
4    |   12<br />
5    |   12<br />
6    |   13<br />
7    |   14<br />
8    |   14

select id,itemprice from Table1 <br />
where <br />
(select count(i1.itemprice) from Table1 as i1 where i1.itemprice=Table1.itemprice)=1<br />
<br />
and id in( (select top 1  id from Table1 where <br />
(select count(i1.itemprice) from Table1 as i1 where i1.itemprice=Table1.itemprice)=1 order by id asc )  <br />
, (select top 1  id from Table1 <br />
where <br />
(select count(i1.itemprice) from Table1 as i1 where i1.itemprice=Table1.itemprice)=1 order by id desc))

Select MinUniquePrice, ( Select Top(1) ID from #MyTable T where T.ItemPrice=MinUniquePrice ) as MinPriceID,
	MaxUniquePrice, ( Select Top(1) ID from #MyTable T where T.ItemPrice=MaxUniquePrice ) as MaxPriceID
From
(
	Select min(ItemPrice) as MinUniquePrice, max(ItemPrice) as MaxUniquePrice
	 From
		( select ItemPrice, Count(*) as ItemPriceCount 
			from #Mytable 
			group by ItemPrice 
			Having Count(*) = 1 
		) as MyTableWithUniqueItemPrices
) As MyTableWithMinMaxItemPrices