SQL Server/T-SQL Tutorial/Query/arithmetic operator

Материал из SQL эксперт
Перейти к: навигация, поиск

The arithmetic operators in order of precedence

   <source lang="sql">
  • Multiplication

/ Division % Modulo (Remainder) + Addition - Subtraction A SELECT statement that calculates the balance due 13> create table Billings ( 14> BankerID INTEGER, 15> BillingNumber INTEGER, 16> BillingDate datetime, 17> BillingTotal INTEGER, 18> TermsID INTEGER, 19> BillingDueDate datetime , 20> PaymentTotal INTEGER, 21> CreditTotal INTEGER 22> 23> ); 24> 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> SELECT BillingTotal, PaymentTotal, CreditTotal, 3> BillingTotal - PaymentTotal - CreditTotal AS BalanceDue 4> FROM Billings 5> GO BillingTotal PaymentTotal CreditTotal BalanceDue


------------ ----------- -----------
        165          123         321        -279
        165          123         321        -279
        165          123         321        -279
        165          123         321        -279
        165          123         321        -279
        165          123         321        -279
        165          123         321        -279
        165          123         321        -279
        165          123         321        -279
        165          123         321        -279

(10 rows affected) 1> 2> drop table Billings; 3> GO</source>