Q:

How to change row order using order & group in PgAdmin, sql?

I would like to re-order rows from two columns in an existing table without creating a new one. I have this script, that works, table name test.table:
   SELECT value, variety
    FROM test.table
    group by value, variety
    order by value, variety;

I have tried update and alter table, but I can not get it to work e.g:
update test.table
SELECT value, variety
FROM test.table
group by value, variety
order by value, variety;

How is this done?

A:

I think you should have a look at this qustion and answer for using group by and orde by together. 

