# A SELECT statement that uses parentheses to control the sequence of operations : Math Calculation « Query « SQL Server / T-SQL Tutorial

Home
SQL Server / T-SQL Tutorial
 1 Query 2 Insert Delete Update 3 Table 4 Table Join 5 Data Types 6 Set Operations 7 Constraints 8 Subquery 9 Aggregate Functions 10 Date Functions 11 Math Functions 12 String Functions 13 Data Convert Functions 14 Analytical Functions 15 Sequence Indentity 16 View 17 Index 18 Cursor 19 Database 20 Transact SQL 21 Procedure Function 22 Trigger 23 Transaction 24 XML 25 System Functions 26 System Settings 27 System Tables Views 28 User Role 29 CLR
 SQL Server / T-SQL Tutorial » Query » Math Calculation
1.25.1.A SELECT statement that uses parentheses to control the sequence of operations
 ```7> 8> 9> create table Billings ( 10>     BankerID           INTEGER, 11>     BillingNumber      INTEGER, 12>     BillingDate        datetime, 13>     BillingTotal       INTEGER, 14>     TermsID            INTEGER, 15>     BillingDueDate     datetime , 16>     PaymentTotal       INTEGER, 17>     CreditTotal        INTEGER 18> 19> ); 20> GO 1> 2> INSERT INTO Billings VALUES (1, 1, '2005-01-22', 165, 1,'2005-04-22',123,321); 3> GO (1 rows affected) 1> INSERT INTO Billings VALUES (2, 2, '2001-02-21', 165, 1,'2002-02-22',123,321); 2> GO (1 rows affected) 1> INSERT INTO Billings VALUES (3, 3, '2003-05-02', 165, 1,'2005-04-12',123,321); 2> GO (1 rows affected) 1> INSERT INTO Billings VALUES (4, 4, '1999-03-12', 165, 1,'2005-04-18',123,321); 2> GO (1 rows affected) 1> INSERT INTO Billings VALUES (5, 5, '2000-04-23', 165, 1,'2005-04-17',123,321); 2> GO (1 rows affected) 1> INSERT INTO Billings VALUES (6, 6, '2001-06-14', 165, 1,'2005-04-18',123,321); 2> GO (1 rows affected) 1> INSERT INTO Billings VALUES (7, 7, '2002-07-15', 165, 1,'2005-04-19',123,321); 2> GO (1 rows affected) 1> INSERT INTO Billings VALUES (8, 8, '2003-08-16', 165, 1,'2005-04-20',123,321); 2> GO (1 rows affected) 1> INSERT INTO Billings VALUES (9, 9, '2004-09-17', 165, 1,'2005-04-21',123,321); 2> GO (1 rows affected) 1> INSERT INTO Billings VALUES (0, 0, '2005-10-18', 165, 1,'2005-04-22',123,321); 2> GO (1 rows affected) 1> 2> 3> SELECT BankerID, 4>     BankerID + 7 * 3 AS OrderOfPrecedence, 5>     (BankerID + 7) * 3 AS AddFirst 6> FROM Billings 7> GO BankerID    OrderOfPrecedence AddFirst ----------- ----------------- -----------           1                22          24           2                23          27           3                24          30           4                25          33           5                26          36           6                27          39           7                28          42           8                29          45           9                30          48           0                21          21 (10 rows affected) 1> 2> drop table Billings; 3> GO```
 1.25.Math Calculation 1.25.1. A SELECT statement that uses parentheses to control the sequence of operations 1.25.2. A SELECT statement that uses the modulo operator 1.25.3. Double the value of a column 1.25.4. Character concatenation can be performed using the plus sign