Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select SUMmed value from result, greater than preset value 1

Status
Not open for further replies.
karlomutschler

karlomutschler

Programmer
Jun 5, 2001
75
DE
Hi all,

From the result of this query I wish to select all of those whose SUMmed revenue_amount for the 3 months is greater than say 250.

SELECT contract_id
,revenue_amount
-- ,SUM(revenue_amount)
FROM contract_turnover
WHERE revenue_date BETWEEN '01.04.2001' AND '01.06.2001'
;

TIA for your help
Kind regards.
Karlo
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
Count records until a record value changes
Replies
2
Views
342
carp
carp
sal21
  • Locked
  • Question
SELECT COUNT distinct
Replies
5
Views
211
sal21
sal21
mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
190
mmiah1982
mmiah1982
szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
199
szeiss
szeiss
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
182
carp
carp

Part and Inventory Search

Sponsor

Back
Top