For each Category or Group Select FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows, Random data

First of all i want to tell you one truth that SQL SERVER never guranteed physical sequence of data. You can retrieve/obtain data logically. Another one is its a bit difficult for SQL SERVER 2000 but easy for 2005. Initially i tried to start with simple example so that beginner can track the post easily:Focus Area:1. TOP N2. Bottom N3. Random Records4. Group or Category wise To follow the below