Hello everyone.... Actually i am working over a problem and to fullfil that i need to do following: 1. Get all the data depending upon some condition from the table. 2. And with each row it should give it's row count. e.g. 1. a b c d 2. e f g h If a b c d and e f g h are columns values. I tried using row_count but all in vain... Can anyone tell me how may i do this... I am just allowed to use query (sql) Urgent help will be greatly appreciated. Thanks..