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 );
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!