From the MS SQL Server online documentation (http://technet.microsoft.com/en-us/library/ms186734.aspx), here is their example that I have tested and works, for retrieving a specific set of rows. ROW_NUMBER requires an OVER, but you can order by whatever you like:
Wash you hair the night before or even a few hours before you do the color job. The coloring clings better to hair without any product in it but I always use conditioner on mine.The products tend to mess with the final color of the hair once it is dry. Thats why most pros say NO to washing for 24 hours and NO products in your hair. They want you to be happy with the finished look.Best thing is, wash the night before, let dry naturally and don't use any products, ie., gel, hair spray, etc.he products tend to mess with the final color of the hair once it is dry. Thats why most pros say NO to washing for 24 hours and NO products in your hair. They want you to be happy with the finished look. Best thing is, wash the night before, let dry naturally and don't use any products, ie., gel, hair spray, etc.
The general rule is to wait four to eight weeks before coloring your hair again but as we just learned itâs not always necessary. If your hair is strong and you use a dye which is not too harsh then you can try to wait a little less than that and everything might still turn out fine. In most cases you can feel if your hair is OK and you can dye it sooner or if itâs damaged and needs to be fixed first. Anyways, regardless of the hair type you have and all other things, thereâs no guarantee that your hair will be severely damaged even if you color it, letâs say, twice in one week.