Advertisement
Guest User

Not a group by SQL

a guest
Sep 25th, 2015
29
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.04 KB | None | 0 0
  1. SELECT taskimpl0_.id AS col_0_0_,
  2.       taskimpl0_.name AS col_1_0_,
  3.       taskimpl0_.subject AS col_2_0_,
  4.       taskimpl0_.description AS col_3_0_,
  5.       taskimpl0_.STATUS AS col_4_0_,
  6.       taskimpl0_.priority AS col_5_0_,
  7.       taskimpl0_.skipable AS col_6_0_,
  8.       taskimpl0_.actualOwner_id AS col_7_0_,
  9.       taskimpl0_.createdBy_id AS col_8_0_,
  10.       taskimpl0_.createdOn AS col_9_0_,
  11.       taskimpl0_.activationTime AS col_10_0_,
  12.       taskimpl0_.expirationTime AS col_11_0_,
  13.       taskimpl0_.processId AS col_12_0_,
  14.       taskimpl0_.processSessionId AS col_13_0_,
  15.       taskimpl0_.processInstanceId AS col_14_0_,
  16.       taskimpl0_.deploymentId AS col_15_0_,
  17.       taskimpl0_.subTaskStrategy AS col_16_0_,
  18.       taskimpl0_.parentId AS col_17_0_
  19. FROM DBALLO05.Task taskimpl0_
  20.     INNER JOIN DBALLO05.PeopleAssignments_PotOwners potentialo1_
  21.         ON taskimpl0_.id=potentialo1_.task_id
  22.     INNER JOIN DBALLO05.OrganizationalEntity organizati2_
  23.         ON potentialo1_.entity_id=organizati2_.id
  24. WHERE organizati2_.id IN (? , ? , ?)
  25. GROUP BY taskimpl0_.id
  26. ORDER BY taskimpl0_.id ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement