Click here to Skip to main content
13,053,891 members (59,564 online)
Click here to Skip to main content

Stats

1.1K views
Posted 18 Jan 2013

SQL QUERY Question to get Average without using AVG()

, 18 Jan 2013
How can I modify the query below to show "average dollar value for Orders" and "average dollar value for OrderItems" side by side in columns. The query below would combine them. Thank you.SELECT (COUNT(Orders.orderid) / SUM(Inventory.price)) AS Orders_AverageFROM ORDERITEMS LEFT...

Revisions


  

Compare Revision Minor Date Status Editor
2 - publicly available No 18-Jan-13 16:34 Available Tharaka MTR
Updates in content.
1 No 18-Jan-13 10:20 Available 7prince

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

7prince
United States United States
This member doesn't quite have enough reputation to be able to display their biography and homepage.

You may also be interested in...

Pro
Pro
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.170713.1 | Last Updated 18 Jan 2013
Article Copyright 2013 by 7prince
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid