[damowangcy]

Isn't this something obvious?

There's use for the wild card, for instance if you need ad hoc query of data during development or testing.

If your table is not properly indexed however, will cause unnecessary select all query even if you didn't intend to.

Junior developer is bad for SQL performance but hey, everyone starts there, so there's nothing to be embarrassed about. Just code on!