Select Single & Select upto --> req when to use?

Hi Guys!

Can u pls tell me when to use select single * & when to use select upto 1 rows. with eg.

Thanks.