[ Zack0_45 @ 19.04.2013. 23:54 ] @
Pozdrav svima Imam sledece pitanje,kako da uz pomog SQL select upita izvucem sledece: 1) top5 najcesce susretanih brojeva u koloni num6; 2) top5 najcesce susretanih brojeva (bez da ukljucujem brojeve kolone num6). U obzir treba uzeti sve 5 kolone (num1 - num5) ,a ne svaku kolonu posebno. Code: CREATE TABLE `lottery` ( `num1` int(2) NOT NULL, `num2` int(2) NOT NULL, `num3` int(2) NOT NULL, `num4` int(2) NOT NULL, `num5` int(2) NOT NULL, `num6` int(2) NOT NULL, UNIQUE KEY `no_dupe` (`num1`,`num2`,`num3`,`num4`,`num5`,`num6`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; LOCK TABLES `lottery` WRITE; /*!40000 ALTER TABLE `lottery` DISABLE KEYS */; INSERT INTO `lottery` (`num1`, `num2`, `num3`, `num4`, `num5`, `num6`) VALUES (1,2,6,10,20,38), (1,2,6,19,45,27), (1,2,10,39,48,13) ........................ ........................ ~ 1000 reda su dodata jos ); Hvala unapred! |