Print Page | Close Window

Use of count and group by

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1730
Printed Date: 29 March 2026 at 5:16am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Use of count and group by
Posted By: ngaisteve1
Subject: Use of count and group by
Date Posted: 10 April 2003 at 3:29am
http://www.aspmessageboard.com/forum/printMessage.asp?M=571028&F=27&P=1">View a printable version of this message! I use this to get my requeser list (attachment) but I only can get the requester and total field correct. How to I get the pending and the issue column?

sql = "SELECT emp.emp_department, sr.requester, count(requester) as theNum, requisition_id "
sql = sql & "FROM inventory_system.stock_requisation as sr, intranet.citylink_employee as emp "
sql = sql & "WHERE sr.requester = emp.emp_userid AND sr.active_status = 'Active' GROUP BY sr.requester"

Attachment is in
http://www.htmlforums.com/attachment.php?s=&postid=149155 - http://www.htmlforums.com/attachment.php?s=&postid=149155



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net