Aggregate Function MAX, SUM
hello friends..
Does MAX as a aggregate function works on the column of datatype char of length 10
as.
serialno [char] [10] [allow null]
1
2
3
9
18
select MAX(serialno) from table1 ?? What will be the output?
Do you think 18 ? ...NO it gives 9 as Max(serialno)
Why??
|