select statement inherent sorting

Group by and distinct do inherent sorting of data in a select statement so need not have order by in some cases.