Kód: Vybrať všetko
SELECT season.player AS player, SUM(season.goals) AS goals, SUM(season.assists) AS assists, SUM(season.playedMatches) AS playedMatches, SUM(season.penaltyMinutes) AS penaltyMinutes, SUM(season.minutesPlayed) AS minutesPlayed, SUM(season.goalsAgainst) AS goalsAgainst FROM Season season WHERE TEAM_ID = :team and LEAGUE = :league GROUP BY season.playerId ORDER BY SUM(season.goals) + SUM(season.assists) DESC, goals DESC, playedMatches ASCKód: Vybrať všetko
Criteria criteria = hibernateSession
.createCriteria(Season.class);
criteria.add(Restrictions.eq("team_id", team));
criteria.add(Restrictions.eq("league", league));
criteria.setProjection(Projections
.projectionList()
.add(Projections.property("player").as("player"))
.add(Projections.sum("goals").as("goals"))
.add(Projections.sum("assists").as("assists"))
.add(Projections.sum("playedMatches").as("playedMatches"))
.add(Projections.sum("penaltyMinutes").as("penaltyMinutes"))
.add(Projections.sum("minutesPlayed").as("minutesPlayed"))
.add(Projections.sum("goalsAgainst").as("goalsAgainst"))
.add(Projections.sqlProjection(
"sum(goals) + sum(assists) as total",
new String[] { "total" },
new Type[] { StandardBasicTypes.INTEGER }), "total")
.add(Projections.groupProperty("player")));
criteria.addOrder(Order.desc("total"));
criteria.addOrder(Order.desc("goals"));
criteria.addOrder(Order.desc("playedMatches"));