|
|
Example: Obtaining SQL column totals You have an e-commerce web site that stores all sales data in the Amount column of the Sales table in your Microsoft SQL Server database. Every day at 11:45pm you would like a text message sent to your Blackberry with the total sales figures for that day. Enter the following SQL Select statement in the Attention! AM SQL Agent:
Select Sum(Amount)
|
![]() |
|
Privacy/Terms
Copyright © 2007 - All rights reserved. |