Finding Duplicates with SQL

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 

problem: displaying list of bday boy/girl in next (30/ according to your own choice ) days from the current date. solution: im using the sql to select the date of birth, for displaying, you can use whatever you want, like gridview, datalist etc. hereby the sql command: SELECT     DateOfBirth FROM         someTablename WHERE     (DateOfBirth < GETDATE())