not approvable for children

Please verify your age to see content (format: YYYY-MM-DD):
- -
change the form values!
linuxweb.net

lnxwbtag
improve websites creatively

en

secs click inside to pause/play next video

CMS Corporate Design Apache fine tuning Linux ( ) linuxweb.net webdesign ritterhude

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: 15989

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

like dislike
0
0
Bewerten:           Rating:2.96

Expand/show comments

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




BOTCHECK: Enter this string : captcha here: to verify you're human.
192 Character(s) Remaining
to prevent slamming comments, post will be checked for bad content and released to public when passed.

letzte Aktualisierung 2024-04-27 09:49:25 von admin
Graphics by GIMP
nickname:
chat

Möchten Sie Cookies erlauben?

Es handelt sich dabei nur um technische Cookies. Sie haben die Wahl:


Lesen Sie mehr in unseren Datenschutzrichtlinien

configure Configure
countercountercountercountercountercountercountercounter

To Top
neu in 2017
Visitors
Content Management System News Xwax Linux livestreams Bilder Statistics live streams Welcome Shorties Linux CMS OpenSource linuxweb.net improve websites

Content Management System