Arithmetic SUBTRACT operator

SQL Server Query

            
SELECT  

    ProductID,  

    ProductName,  

    UnitsInStock - 5 AS RemainingStock  

FROM Products;

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

    .Select()  

    .Columns("ProductID", "ProductName")  

    .Column(new ColumnArithmatic("UnitsInStock").SUBTRACT(5)  

    , "NewPrice")  

    .From("Products")  

    .Build();

Query build by SqlQueryBuilder

            
SELECT ProductID,
       ProductName,
       UnitsInStock - @pMAIN_2507200130333084230 AS RemainingStock
FROM Products;

Parameters (If used)

Name Value
@pMAIN_2507200130333084230 5

Query Results:

  ProductID ProductName NewPrice RemainingStock
1 1 Chai 0 34
2 2 Chang 0 12
3 3 Aniseed Syrup 0 8
4 4 Chef Anton's Cajun Seasoning 0 48
5 5 Chef Anton's Gumbo Mix 0 -5
6 6 Grandma's Boysenberry Spread 0 115
7 7 Uncle Bob's Organic Dried Pears 0 10
8 8 Northwoods Cranberry Sauce 0 1
9 9 Mishi Kobe Niku 0 24
10 10 Ikura 0 26
11 11 Queso Cabrales 0 17
12 12 Queso Manchego La Pastora 0 81
13 13 Konbu 0 19
14 14 Tofu 0 30
15 15 Genen Shouyu 0 34
16 16 Pavlova 0 24
17 17 Alice Mutton 0 -5
18 18 Carnarvon Tigers 0 37
19 19 Teatime Chocolate Biscuits 0 20
20 20 Sir Rodney's Marmalade 0 35
21 21 Sir Rodney's Scones 0 -2
22 22 Gustaf's Knäckebröd 0 99
23 23 Tunnbröd 0 56
24 24 Guaraná Fantástica 0 15
25 25 NuNuCa Nuß-Nougat-Creme 0 71
26 26 Gumbär Gummibärchen 0 10
27 27 Schoggi Schokolade 0 44
28 28 Rössle Sauerkraut 0 21
29 29 Thüringer Rostbratwurst 0 -5
30 30 Nord-Ost Matjeshering 0 5
31 31 Gorgonzola Telino 0 -5
32 32 Mascarpone Fabioli 0 4
33 33 Geitost 0 107
34 34 Sasquatch Ale 0 106
35 35 Steeleye Stout 0 15
36 36 Inlagd Sill 0 107
37 37 Gravad lax 0 6
38 38 Côte de Blaye 0 12
39 39 Chartreuse verte 0 64
40 40 Boston Crab Meat 0 118
41 41 Jack's New England Clam Chowder 0 80
42 42 Singaporean Hokkien Fried Mee 0 21
43 43 Ipoh Coffee 0 12
44 44 Gula Malacca 0 22
45 45 Rogede sild 0 0
46 46 Spegesild 0 90
47 47 Zaanse koeken 0 31
48 48 Chocolade 0 10
49 49 Maxilaku 0 5
50 50 Valkoinen suklaa 0 60
51 51 Manjimup Dried Apples 0 15
52 52 Filo Mix 0 33
53 53 Perth Pasties 0 -5
54 54 Tourtière 0 16
55 55 Pâté chinois 0 110
56 56 Gnocchi di nonna Alice 0 16
57 57 Ravioli Angelo 0 31
58 58 Escargots de Bourgogne 0 57
59 59 Raclette Courdavault 0 74
60 60 Camembert Pierrot 0 14
61 61 Sirop d'érable 0 108
62 62 Tarte au sucre 0 12
63 63 Vegie-spread 0 19
64 64 Wimmers gute Semmelknödel 0 17
65 65 Louisiana Fiery Hot Pepper Sauce 0 71
66 66 Louisiana Hot Spiced Okra 0 -1
67 67 Laughing Lumberjack Lager 0 47
68 68 Scottish Longbreads 0 1
69 69 Gudbrandsdalsost 0 21
70 70 Outback Lager 0 10
71 71 Flotemysost 0 21
72 72 Mozzarella di Giovanni 0 9
73 73 Röd Kaviar 0 96
74 74 Longlife Tofu 0 -1
75 75 Rhönbräu Klosterbier 0 120
76 76 Lakkalikööri 0 52
77 77 Original Frankfurter grüne Soße 0 27