Traveller
6.11.2012 - 01:14
select repeatType,duration,timeStart,timeEnd from `Event` where ...
подскажите пожалуйста как сделать выборку по уникальным значениям поля dateSearch
Traveller
6.11.2012 - 01:55
select repeatType,duration,timeStart,timeEnd from `Event` where distinct(dateSearch) ?
не работает
Игорь_Vasinsky
6.11.2012 - 07:54
distinct in the SELECT
_____________
HTML, CSS (Bootstrap), JS(JQuery, ExtJS), PHP, MySQL, MSSql, Posgres, (TSql, BI OLAP, MDX), Mongo, Git, SVN, CodeIgnater, Symfony, Yii 2, JiRA, Redmine, Bitbucket, Composer, Rabbit MQ, Amazon (SQS, S3, Transcribe), Docker
killer8080
6.11.2012 - 11:00
SELECT `repeatType`, `duration`, `timeStart`, `timeEnd` FROM `Event` GROUP BY `dateSearch`