Thank you for your replies .

yes it was a typo..

With this query the result seems not desirable,it is dividing the total records by 4 quartiles blindly.

But my required answer should be in the Ascending order of the records...

Thanks for the help,

Is there a way that we can assign this percentile values(25,50,75,100) to each field in the table in the same query?