say i have a table (id, name, subject) and i want to list out all the records, but if the name is the same i want to list it only once.
example if i just list out all the records i would get something like
james, math
james, science
james, history
bob, math
bob, humanities
bob, psychology
but what i want is just to list out the name once and if it is already listed then to skip all the other entries where the name==name, like inplace of the above i would get
james
bob
that make any type of sence
