I have a problem that might actually be quite trivial; however, I do not find a solution to it. Here it is:

You have the following table TAB

ID | Name |...
1 | Mouse |
2 | Duck |
3 | Mouse |
4 | Goose |

I want to select all rows where the name is the identical; i.e. in this example, I want to select row 1 and 3. Does anyone know the correct syntax for this statement? (I tried to solve it by using a view, but that wasn't the right track....)

-Thanks a lot!