` Totalling a computed field in SQL (J Shankar ) - Icetips Article

Templates, Tools and Utilities for Clarion Developers
	Home Products Download Documentation Demos Support Articles About Buy ALL PRODUCTS Build Automator Checkbox Fixer Icetips Utilities Magic Buttons Magic Entries Magic Locks OutlookBar Power ToolBar Report Previewer SQL Templates TaskPanel Window Fixer XP Theme Xplore GOLD SUBSCRIPTION SILVER SUBSCRIPTION SOLO SUBSCRIPTION Compare Gold/Silver Products Documentation Demos Free SQL Stuff Other Free Stuff PAR2 files Tips & Tricks - NEW Icetips Blog Icetips News Icetips on Facebook Icetips on Twitter Icetips on Youtube All Articles Search articles Top Ten articles Articles by Category Video tutorials What is Clarion? Support Options Live Support Email & Mail Icetips Blog Icetips on Twitter Gold Subscription Silver Subscription Solo Subscription Recurring Subscription Compare Gold & Silver Renew Your Subscription Multiple Copy Pricing

Icetips Article

Back to article list Search Articles Add Comment Printer friendly Direct link

Par2: Totalling a computed field in SQL
2007-12-10 -- J Shankar

select ID, sum(QTY), Sum(Extension), Sum(DiscountExt),
       Sum(Case When discountext = 0 then 
          extension 
      else discountext end) AS 'SoldPrice'
 from partsolds
 group by ID

Today is November 21, 2024, 8:14 am
This article has been viewed 35234 times.

Back to article list Search Articles Add Comment Printer friendly

Lost Password

Subscribe

Gold Subscription
Buy Now

Silver Subscription
Buy Now

Solo Subscription
Buy Now

Multiple Copy Pricing

Renew Subscription

Templates, Tools and Utilitiesfor Clarion Developers

Icetips Article

Templates, Tools and Utilities
for Clarion Developers