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.
Wash your hair before you scrunch your hair. You need to wash your hair for this method because you need to blow dry your wet hair with a diffuser to make your hair wavy. Typically, people with wavy hair also have dry hair. You can buy a moisturizing shampoo and conditioner to wash your hair.Or you can use whatever shampoo works best for your hair type.ash your hair before making your bun. Or spray the midsection and ends of your hair with a spray bottle so that it is damp. You want your hair damp for this method because you need your hair to dry in the bun in order to make it nice and wavy.