I'm new in DB world, so if you can help me it would be great.
I have filtered some data and got a table with data, but need to filter them again. Picture might help you. For me, it is pretty complicated. (I made this tables / picture just to illustrate my problem, I'm not allowed to post real data because they are business secret)
I have data in
Table 1 (HAVE), and need to get data in
table 2 (WANT). Need to take data from first table, but result is based on first appearing in
table 1 based on name. When I "find" new "name" (in real life there are some other data, but it is not matter because it is also string), take that row and put it in new table. Then second name, third name ... it depends how many different names are in first table.