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"> 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 |