SQL Server - SQL-how to use Rollup command in the following output

Asked By vinayak muru on 03-Dec-13 12:28 AM
I have table like,

create table vin(id int,coun char(20),amount int)

The above table have the record the like this,

id country         amount
1 ind                 200
2 ind                 300
3 pak                 400
4 ind                 500

i just  need a quantity column sum of the country.

I need a output for the below Format:

id country    quantity         amount
1 ind                 3                 200
2 ind                                 300
4 ind                                 500
3 pak                 1            400