Find Remove Delete duplicate rows in sql

select MyId,COUNT(1) from #MyTable
group by MyId
having COUNT(1) > 1

--Select duplicate records
with CTE
AS
(SELECT MyId, RANK() OVER (PARTITION BY MyId ORDER BY num) rnk
FROM(SELECT *, ROW_NUMBER() OVER(ORDER BY MyId) num
FROM #MyTable
) X
)
Select * from CTE
WHERE rnk > 1

--Delete Duplicate records
with CTE
AS
(SELECT MyId, RANK() OVER (PARTITION BY MyId ORDER BY num) rnk
FROM(SELECT *, ROW_NUMBER() OVER(ORDER BY MyId) num
FROM #MyTable
) X
)
delete from CTE
WHERE rnk > 1

good article to study in abrod

http://getahead.rediff.com/report/2009/oct/06/career-study-us-makes-more-sense-today.htm

World's top 10 mobile - 2009

http://business.rediff.com/slide-show/2009/oct/01/slide-show-1-tech-top-10-mobile-phones.htm

String Padding C#

string sValue = "563";
string sOutput = sValue.PadLeft(5, '0');

What is dual listing -- Good article ADR/GDR

http://business.rediff.com/report/2009/sep/29/perfin-what-is-dual-listing-and-why-india-may-not-adopt-it.htm

look young

Anyone who stops learning is old, whether at twenty or eighty. Anyone who keeps learning stays young. The greatest thing in life is to keep your mind young.

Silverlight tutorials

http://www.davidezordan.net/blog/?p=1436

http://www.smartwebcontrols.com/video/