You are viewing a single comment's thread. Return to all comments →
Recommended to use this -- in ORACLE
select sum(population) from city where lower(district) = 'california';
select sum(population) from city
where lower(district) = 'california';
Reason: This will take any input ie., case-sensitive as well case-insensitive.
Seems like cookies are disabled on this browser, please enable them to open this website
Revising Aggregations - The Sum Function
You are viewing a single comment's thread. Return to all comments →
Recommended to use this -- in ORACLE
Reason: This will take any input ie., case-sensitive as well case-insensitive.