Any Difference in GroupBy and OrderBy Using Numerals
is there any difference in using numerals for ordering as opposed to using the names for grouping by or ordering by clauses ?
example 1:
select
name,
TO_CHAR (empdate,'yyyy') yeartodate,
from
table1
group by
name,
TO_CHAR (empdate,'yyyy')
order by
name,
TO_CHAR (empdate,'yyyy')
example 2:
select
name,
TO_CHAR (empdate,'yyyy') yeartodate,
from
table1
group by
1,
2
order by
1,
2