DISTINCT and TOP Keywords together

I was just thinking how I resolved the issue regarding the TOP and DISTINCT keywords together. I scratch my  head and realize yes, that was the solution and here it is:


SELECT DISTINCT top 5 ID, NAME FROM Customer 


Yes it is solved..thanks sometimes you have to memorize your old days programming. You can not remember everything every time. 


Gud Luck..

Comments