i am sorry , i should have made that clear before.. i just know how many records are there, but there is no index column as such to select the...

Kenneth.  but, i am totally a newbie to this sql world is it possible for you to tell me in detail how to procede with the query u have given...