I have one table it looks like below
ID | PName | Price
___+_______+______
1 |some |2000
2 |some |3000
3 |some |250
now i need to query for get following result
ID | PName | Price |Total Price
___+_______+________+____________
1 |some |2000 |2000
2 |some |3000 |5000
3 |some |250 |5250
Total Price= Price + Total Price
How to get above result using sql query