Different number-crunching administrators are utilized in SQL to be specific Addition (+), Subtraction (-), Multiplication (*), Division (/), Modulus (%).
For the further examples we will be referring to the following base table:
Table: BOOKS
BookNo Name Cost Discount 9871 Nancy Drew 200 5% 9560 Goosebump 250 10% 9810 Sherlock Holmes 300 15% 8700 The Blue Umbrella 200 6% 5086 Gulliver Travels 160 4% 1272 Hellen Keller 150 4% 1) Addition (+)
It is utilized to perform addition procedures on the information things, things incorporate either single section or different segments.
Implementation:
SELECT bookno, name, cost, discount, cost+50 AS "Final Cost" FROM BOOKS;
Output
BookNo Name Cost Discount Final Cost 9871 Nancy Drew 200 5% 250 9560 Goosebump 250 10% 300 9810 Sherlock Holmes 300 15% 350 8700 The Blue Umbrella 200 6% 250 5086 Gulliver Travels 160 4% 210 1272 Hellen Keller 150 4% 200 Similarly, we can do the addition of two columns too.
2) Subtraction (-)
It is utilized to perform subtraction procedures on the information things, things incorporate either a single section or different segments.
Implementation:
SELECT bookno, name, cost, discount, cost-discount AS "Final Cost" FROM BOOKS;
Output
BookNo Name Cost Discount Final Cost 9871 Nancy Drew 200 12.50 237.50 9560 Goosebump 250 30.00 270.00 9810 Sherlock Holmes 300 52.50 297.50 8700 The Blue Umbrella 200 15.00 235.00 5086 Gulliver Travels 160 8.40 201.6 1272 Hellen Keller 150 8.00 192.00 3) Multiplication (*)
It is utilized to perform multiplication procedures on the information things, things incorporate either a single section or different segments.
Implementation:
SELECT bookno, name, cost, discount, cost*discount AS "Final Cost" FROM BOOKS;
Output
BookNo Name Cost Discount Final Cost 9871 Nancy Drew 200 12.50 2500 9560 Goosebump 250 30.00 7500 9810 Sherlock Holmes 300 52.50 15750 8700 The Blue Umbrella 200 15.00 3000 5086 Gulliver Travels 160 8.40 1344 1272 Hellen Keller 150 8.00 1200 4) Division (/)
It is utilized to perform division procedures on the information things, things incorporate either a single section or different segments.
Implementation:
SELECT bookno, name, cost, discount, cost/discount AS "Final Cost" FROM BOOKS;
Output
BookNo Name Cost Discount Final Cost 9871 Nancy Drew 200 12.50 16.00 9560 Goosebump 250 30.00 8.33 9810 Sherlock Holmes 300 52.50 5.71 8700 The Blue Umbrella 200 15.00 13.33 5086 Gulliver Travels 160 8.40 19.04 1272 Hellen Keller 150 8.00 18.75 5) Modulus (%)
This operator is used to get the remainder when the division operation is performed with the data.
Implementation:
SELECT bookno, name, cost, discount, cost%discount AS "Final Cost" FROM BOOKS;
Output
BookNo Name Cost Discount Final Cost 9871 Nancy Drew 200 12.50 0 9560 Goosebump 250 30.00 10 9810 Sherlock Holmes 300 52.50 37.5 8700 The Blue Umbrella 200 15.00 5 5086 Gulliver Travels 160 8.40 0.4 1272 Hellen Keller 150 8.00