Hi,
I'm trying to write a query, which produces a list of users, whose telephone call costs total over 15.00 for the month, but I'm having difficulty. Here's my query;
I've tried a few different variations of this, but I'm not getting anywhere. Any help would be much appreciated. Thanks in advance.
I'm trying to write a query, which produces a list of users, whose telephone call costs total over 15.00 for the month, but I'm having difficulty. Here's my query;
Code:
SELECT userid, username, SUM(netamt) FROM EMNCommon HAVING (SUM(netamt) >= '15.0000') AND (transdate > GETDATE() - 30) GROUP BY username
Comment