Topic profile page for GROUP BY.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: GROUP BY.
Topic "Group by" was discussed 27,107 times on 2,855 sites in last 3 months
Started 12 hours, 19 minutes ago (2009-11-26 10:02:00)
by bgfs
I have a task where I need to populate a global group in active directory with users copied from an a nested OU in the same parent OU. I've never used scripts before but as this appears to be the only way of copying mass users across I have to give it a try. Where do I start and how and where do I actually run the script.
Started 12 hours, 22 minutes ago (2009-11-26 09:59:00)
by littlemookie
Hi Chaps, I have a recordset that pulls data from a database, then presents the data in a table. The data is grouped by 'projid', repeated for every 'projid', with a show/hide control, to show all the 'jobid's' relating to that particular 'projid' This is what I have so far: Code: SELECT tbl_projects.projid, tbl_projects.projtitle, tbl_projects.projdue, DATE_FORMAT(tbl_...
Started 19 hours, 23 minutes ago (2009-11-26 02:58:00)
by kool_samule
Hi Chaps, I have a recordset that pulls data from a database, then presents the data in a table. The data is grouped by 'projid', repeated for every 'projid', with a show/hide control, to show all the 'jobid's' relating to that particular 'projid' This is what I have so far: Code: SELECT tbl_projects.projid, tbl_projects.projtitle, tbl_projects.projdue, DATE_...
Started 20 hours, 24 minutes ago (2009-11-26 01:57:00)
by tijimathew
Dear all I would like to know if the optimized sql can be generated with the group by clause containing the actual definition of an output mapping rather than just the input columns indvidually. I need to generate a query like this SELECT decode(a.col1,'Y', a.mynum, b.mynum), sum(a.amt) from tab1 a, tab2 b where a.key = b.key group by decode(a.col1,'Y', a.mynum, b....
Started 1 day, 9 hours ago (2009-11-25 12:29:00)
by nitsmooth
select s.survey_id from survey s join survey_response sr on s.survey_id = sr.survey_id join survey_answer sa on sa.answer_id = sr.answer_id group by s.survey_id having sum(sa.weight)= sum(sa.high) Result ----------- survey_id 443 446 450 451 453 458 459 461 but i want the count of the s.survey_id i.e 8 so i do this: select count(s.survey_id ) from survey s join survey_response sr on s....
Started 1 day, 10 hours ago (2009-11-25 11:53:00)
by Airbisk
Hi, I have a table that contain jobdate, staffname, overtimehrs, standardhrs field. Now I can sum the number of overtimehrs and standardhrs using Group by and Sum but when I add the criteria for a date range to be selected (Between [Start date] and {End Date]) the query returns multi lines for each staffname everytime the jobdate is different. Is there a way of selecting a date range with out...
Started 1 day, 14 hours ago (2009-11-25 07:31:00)
by user12273726
Hey All, This is pretty much my first time tackling a very complex SQL Statement but the boss is adamant about it. Anyways here is the information. I have 3 Tables. Table one Contains Work Order Infromation that will be listed or grouped. Table 2 and Table 3 house information that needs to be summed (Estimate hours and Actual Hours). So my SQL ...
Started 1 day, 15 hours ago (2009-11-25 06:51:00)
by user12263058
hello i am using hr schema 2 tables hr.employees and hr.departments and my target table have following columns dept_id,dept_name,dept_manager full name and dept_total_salary In interface i have join these 2 tables using employees.employee_id=departments.department_id also i have use sum function at the target salary column. But i am not getting the...
Started 1 day, 22 hours ago (2009-11-24 23:40:00)
by beige
How to build a report in webi for Group By SQL without using custom sql option. SQL sample: select sum(sale_num) from tbl_sale group by sale_date In Universe, Sale object has sale_num and sale_date. Thanks.
Started 1 day, 22 hours ago (2009-11-24 23:38:00)
by TBA
I love the group by date function...I rely on it! but i often find it is greyed-out and not avialable to use for a variable, despite it being date data. Any tips on ensuring how to get this work?. I understand it might be a problem with files that started life at 2003 files, even if saved as 2007 files? cheers Theo
Started 2 days, 7 hours ago (2009-11-24 14:37:00)
by TBA
I love the group by date function...I rely on it! but i often find it is greyed-out and not avialable to use for a variable, despite it being date data. Any tips on ensuring how to get this work?. I understand it might be a problem with files that started life at 2003 files, even if saved as 2007 files? cheers Theo...
Started 6 days, 8 hours ago (2009-11-20 13:30:00)
by AndreaV
Is there a way to group messages, like in the conversation view, not by subject or conversation index, but by involved people, ie: sender and recipient? I'd like to be able to see in a glance all messages received from a particular person and my messages to that very person. Something like group by 'FROM/TO'... Maybe a VBA script could copy all recipients and sender of each ...
Started 6 days, 11 hours ago (2009-11-20 10:30:00)
by AndreaV
( Is there a way to group messages, like in the conversation view, not by subject or conversation index, but by involved people, ie: sender and recipient? I'd like to be able to see in a glance all messages received from a particular person and my messages to that very person. Something like group by 'FROM/TO'... Maybe a VBA script could copy all recipients and sender of ...
Started 6 days, 3 hours ago (2009-11-20 19:13:00)
by MAW30
The following is generated for historical stock data w/ the folowing columns: dtDateTime, fltOpen, fltHigh, fltLow, fltClose, dVolume, fltSplitAdj I am multiplying the historical data x a variable for the past splits. furthermore whether or not it is necessary I am breaking out the weeks, months, years for the dates in order to gather info to group by. So far it works fine but I can't make it...
Started 6 days, 11 hours ago (2009-11-20 10:29:00)
by AndreaV
Is there a way to group messages, like in the conversation view, not by subject or conversation index, but by involved people, ie: sender and recipient? I'd like to be able to see in a glance all messages received from a particular person and my messages to that very person. Something like group by 'FROM/TO'... Maybe a VBA script ...
Started 1 week ago (2009-11-19 21:29:00)
by Ashish Malhotra
I have a Project Tasks list which I want to group by "Assigned to" column..but in Modify View Groping Settings, it is not showing me Assigned to Column propably because some to the Items has multiple users in "Assigned to" column... Is there a way i could group by "Assigned to" with multiple selections enabled
Started 3 days, 6 hours ago (2009-11-23 16:08:00)
by Westside2008
Hi, I'm trying to write a query that will output my data like this: office_id, display_name, work_year, employee_count 1, Chicago Office, 2009, 20 1, Chicago Office, 2008, 19 1, Chicago Office, 2007, 22 2, New York Office, 2009, 15 2, New York Office, 2008, 12 Here is my current SQL: SELECT o.office_id, o.[display_name], COUNT(x.employee_id) AS Employee_Count FROM employees_...
Started 1 week, 1 day ago (2009-11-18 14:54:00)
by hkbarnett
Many of the functions on the ribbon are inaccessible. I noticed that the file name shown at the top of the spreadsheet is followed by "[Group]". I have never seen that before on any spreadsheet, and have no idea how it got labeled that way. I assume that has something to do with the inability to access some functions, such as ...
