Author Topic: Group without sort  (Read 2967 times)

mukul

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 9
    • View Profile
Group without sort
« on: March 12, 2014, 04:50:39 pm »
one more thing when I am applying grouping then it sorting the data according to group dataindex, but I don't want to use this sorting.

Please let me know how I can disable the sorting in case of grouping.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Group without sort
« Reply #1 on: March 12, 2014, 09:39:44 pm »
sorting goes along with the grouping. There is no option to group data without sorting.

It would be quite inefficient to group data without sort.

SQL also sorts the columns when grouping is applied to the fields. ( group by )
« Last Edit: March 12, 2014, 10:15:06 pm by paramquery »