|
Custom Search
| |
|
Perform Arithmetic Operations When you need to perform calculations in SQL statement, you use arithmetic expression. An arithmetic expression can contain column names, numeric numbers, and arithmetic operators. Read Prerequisites for this tutorial and practices if you haven't done so. Consider the following facts when using arithmetic operations in a SELECT statement:
Most of the queries in the tutorials need Northwind MySQL database, you can download the database script on this page. Practice #1: Arithmetic operation in SQL SELECT statement. /*
Query result set - 2155 rows returned: Practice #2: Modulo arithmetic operation in SQL SELECT statement. /*
Query result set - 77 rows returned: Practice #3: Integer division arithmetic operation in SQL SELECT statement. /*
Query result set: Practice #4: Integer division arithmetic operation in SQL SELECT statement - round up. /*
Query result set: Practice #5: Use Unary minus to change the sign of an argument in SQL SELECT statement. /*
Query result set: Other tutorials in this category 1. The Basic SELECT Statement |
Copyright © 2024 GeeksEngine.com. All Rights Reserved. This website is hosted by HostGator. No portion may be reproduced without my written permission. Software and hardware names mentioned on this site are registered trademarks of their respective companies. Should any right be infringed, it is totally unintentional. Drop me an email and I will promptly and gladly rectify it. |
Home | Feedback | Terms of Use | Privacy Policy |