diff b/w select single * & select upto 1 rows?

pls give the differnece diff b/w select single * & select upto 1 rows? But i heard that select upto 1 rows with fetch the data based on the gn condition and perform aggregation on it and displays the topmost record? is that true? pls give ur review?

Thanks in advance....