The Zack Posted May 17, 2011 Well, I am not hiring anybody, I just need quick help. For those of you who have experience with SQL, please help me with a query.. I am trying to write a query that would help me retrieve multiple counts and also have sub totals and total. I am looking for something like this: Account_ID Company Number_Of_Customers 123 XYZ 1234 234 ABC 478 sub_total: Account_ID Company Number_Of_Customers 123 XYZ 1234 234 ABC 478 sub_total: TOTAL: Quote Share this post Link to post Share on other sites
The Zack Posted May 17, 2011 This should be simple but the multiple counts and the sub total part is what I need help with. And yes, I tried sites like sqltraining.com.. no luck. This is something that I need tonight (more of right now). Quote Share this post Link to post Share on other sites
Axmed-InaJaad Posted May 17, 2011 sorry abti. most of the nerds are asleep. best of luck. Quote Share this post Link to post Share on other sites
The Zack Posted May 17, 2011 I know, I should've done this work earlier today, this is what I get for being a slacker. Use your magic Najaad tricks and help me out. Quote Share this post Link to post Share on other sites
Aaliyyah Posted May 17, 2011 I have no clue what I just read lol.. Hope someone can help u out Quote Share this post Link to post Share on other sites
The Zack Posted May 17, 2011 Lol thanks for reading and trying. It looks like I will be out of luck tonight. Quote Share this post Link to post Share on other sites
Aaliyyah Posted May 17, 2011 yea guy I so wanted to help u ..haye habeen wacan. Quote Share this post Link to post Share on other sites
The Zack Posted May 17, 2011 Aaliyyah;719936 wrote: yea guy I so wanted to help u ..haye habeen wacan. I know, I know and I appreciate it. Good night to u as well. Quote Share this post Link to post Share on other sites