Hi ryutenkan,
Refer the below query and write in the VB.Net code.
Or create a stored procedure and call the stored procedure in code.
For calling stored procedure refer below article.
SQL
CREATE Table1(NAME VARCHAR(50),FIRSTNAME VARCHAR(50),POINTS INT)
INSERT INTO Table1 VALUES('Alpha','Alphazy',10)
INSERT INTO Table1 VALUES('Alpha','Alphazy',12)
INSERT INTO Table1 VALUES('Beta','Betazy',9)
INSERT INTO Table1 VALUES('Beta','Betazy',15)
CREATE Table2(NAME VARCHAR(50),FIRSTNAME VARCHAR(50),POINTS INT)
INSERT INTO Table2
SELECT NAME,FIRSTNAME, MAX(POINTS) POINTS
FROM TABLE1
GROUP BY NAME,FIRSTNAME
SELECT * FROM Table2
Output
| NAME |
FIRSTNAME |
POINTS |
| Alpha |
Alphazy |
12 |
| Beta |
Betazy |
15 |
