Salut à tous,

Je n'arrive pas a mettre un alias pour la nouvelle colonne qui va etre creee dans la requete dessous:

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
SELECT month(r.date),count(r.id),
	 case 
		when (year(current_date)-year(u.dateOfBirth))between 18 and 24 then '18 and 24'
		when (year(current_date)-year(u.dateOfBirth)) between 25 and 34 then '25 and 34' 
	    when (year(current_date)-year(u.dateOfBirth)) between 35 and 44 then '35 and 44' 
	    when (year(current_date)-year(u.dateOfBirth)) between 45 and 54 then '45 and 54' 
	    when (year(current_date)-year(u.dateOfBirth)) between 55 and 64 then '55 and 64'
	    when (year(current_date)-year(u.dateOfBirth)) > 65 then '65 et plus'
		end
  FROM Review r
  JOIN r.user u
  where u.userType = AccessUser or u.userType = PremiumUser
GROUP BY  month(r.date)
Je veux faire un group by sur la nouvelle colonne. Est-ce que c'est possible de mettre un alias apres le mot cle End du Case statement?


Quelqu'un pourra m'aider svp

Cdt,
Neerou