secs

click inside to pause/play

Notice: Server move until 31-08-24, in best case nothing won't be noticeble. But if, stay tuned - everything will be shortly as you know so far.

complex grouping mysql (ranking with groups)

##mysql

from a table i want to create groups by 4 (players) different "Klasse" ordered by KW (strentgh) in one select query.

CREATE TABLE valar_date 
 (id int AUTO_INCREMENT primary key NOT NULL, Name varchar(255), Klasse varchar(255), Resonanz int, KW int, Schaden int,
  Discord tinytext, Anmeldung enum("true","false") DEFAULT "false", Ritual8er varchar(255), Ritual3er varchar(255),
   Setitem varchar(255), Baum varchar(255), position VARCHAR(255) NULL,  FULLTEXT(Name,Klasse))

Each group of 4 must NOT contain same "Klasse" and the next group have to be the next highest KW.
so grp1 contains "Klasse" = 1 "Kreuzritter", 1 "Zauberer", 1 "DÃ¤monenjÃ¤ger", 1 "MÃ¶nch" with the highest KW
grp2: contains "Klasse" = 1 "DÃ¤monenjÃ¤ger", 1 "Zauberer", 1 "Kreuzritter", 1 "Barbar" (2nd best KW constalation)
grpX can have any other constalation by "Klasse" but the next highest KW group
sqlfiddle example: complex grouping solution
explicit some "Klasse" should not grouping with other specific! this can be done by edit:

WHERE (CONCAT(Name)) NOT IN ("Zauberer")

- 1449 Chars - 144 Wörter , Views: 313221

War die Information auf dieser Seite für Sie hilfreich?


0	0

Bewerten: Rating:3.03

Expand/show comments

Was denkst Du? Hinterlasse hier einen Kommentar zu diesem Artikel.
Bisher : 1 Kommentare.

192 Character(s) Remaining

to prevent slamming comments, post will be checked for bad content and released to public when passed.

Hi to all, how is the whole thing, I think every one is getting more from this web site, and your views are fastidious designed for new viewers.https://tonic-greens.mazdaci.com

Hi to all how is the whole thing I think every one is getting more from this web site and your views are fastidious designed for new viewershttpstonicgreensmazdacicom

2024-09-16 12:35:03

letzte Aktualisierung 2024-10-09 07:12:47 von admin