fetched records can be sorted out by order by clause.
record set can be summarized by group by clause.