NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
SQL: Sum,Average,Max,Min,Count,Detail
2588
SQL: Sum,Average,Max,Min,Count,Detail
http://www.codeave.com/asp/code.asp?u_log=22
There are a great many statistics that you can perform on your data with simple sql. Sum, Average, Max, Min, and Count can be derived nearly as easy as showing the complete detail of your data. The following example utilizes our db (trade date, closing price and daily volume) of EPOS (@PointofSale.com) stock trading performance. Each of the statistics are available in a dropdown menu and the sql that is used on the daily volume is displayed.
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark SQL: Sum,Average,Max,Min,Count,Detail: |
|||
Other links at ASP > Tips and Tutorials > Database-related
You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server.
Run create_image_table.sql on your sql server. This database holds some information about your image : size of image, width and height of image.
Run create_image_table.sql on your sql server. This database holds some information about your image : size of image, width and height of image.
Category:
In Active Server Pages, all strings are enclosed in double quotes ("). For example, if you wanted to pull in all orders from the database, the SQL string would look like this:
Category:
If you have an SQL database set up with your web host, a useful tip to know is how to connect to your SQL database via Enterprise Manager. The advantage of knowing
Category:
Shuffling a recordset so that it can be displayed in random order is very useful when programming dynamic Web pages. A database table containing a list of supported vendors or links to advertisers may need to be displayed in a different order each time so that none complain about always being last on the list.
Category:
This application is for the beginners who wonder how to build their own web database system on their own computers. I will use Microsoft FrontPage98 and Microsoft Access in the demonstration. The reader should be familiar with the RDBMS concept and know how to use Microsoft Access tool to build a local database system. They should also have the Northwind.mdb file, which is included in Microsoft Office 97.
Category:
Main Category
194
2041
824
286
175
1802
1238
913
1163
7489
70
909
59
2222
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19538
Categories: 1275
Registered Users: 750
Mailing List Subscribers: 2046
Unique Outgoing Hits: 227874
Pagerank Statistics
PHP News