Selecting rows with highest value within group using virtual table

Hi, Curetnly I have ID (duplicated) column only (Group column does not matter). Starting from this column I want to create a table as below   ID Group Rand_Num Max_Rand_ID 1 A...