Select distinct

I had some confusion regarding

keyword... For example Table

has 5 columns

, and column

has repeated value, and I want to use

keyword to get distinct values while also fetching data from other columns eg.

distinct * from test

(I know the syntax is wrong here, I have written the query to help people get the idea of what I'm trying to do here) Can someone help here? ///edit

ID	DEGREE	AWARDED	ACADEMIC_PERIOD
147	GR	         MS	2022
147	UG           BS	2020
170	GR           MA	2023
170	UG           BA	2018

Expected output is

ID	DEGREE	AWARDED	ACADEMIC_PERIOD
147	GR	         MS	2022
170	GR           MA	2023

found this data on dbastackexchange itself