Hello.! Greetings from Codeziper.
in this article, we will explain how to calculate numbers in SQL.
here we will describe calculating numbers without any math function in SQL.
- Single calculation between two numbers in select cases.
SELECT 100+50;
- Multiple calculations between two numbers in select cases.
SELECT 100+50, 500+20, 399+1, 549+51;
- Calculations between multiple numbers in select cases.
SELECT 10+5*2, 10+20+70;
- Calculate numbers in select cases with the alias.
SELECT 50+50 as sum, 10*10 as multiplication, 50/25 as division ;
( for more information contact us: CodeziperTeam )
Thanks, Regards,
Codeziper and Team.
.jpg)
.jpg)
