Archive for November, 2009

Finding Duplicates with SQL

Nov 27th

problem:
finding the duplicate within sql

solution:
provide table named subscriber, with elements: email

SELECT COUNT(DISTINCT email) AS NumberOfEmail, email FROM subscriber GROUP BY email HAVING (COUNT(email) > 1)

sql

Nov 27th

problem:
make some selection in database OTHER THEN top (10) post

solution:
provide, table named news with element: newsID, newsDate

SELECT * FROM News WHERE (newsID NOT IN (SELECT TOP (10) newsID FROM News AS News_1 ORDER BY newsDate DESC)) ORDER BY newsDate DESC

it will return all post except top 10 post

sql