how about select date(dttm) dt,max(i) from foo group by date(dttm) order by 1;
Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 21 March 2018 at 15:30, Ron Watkins <rwatk...@dssolutions.com> wrote: > I have a table which contains a datetime column: > > > > table|foo|foo|2|CREATE TABLE foo ( > > dttm datetime not null > > i int not null > > ) > > > > I want to select out the max(i) value for each day where there are multiple > records per day. > > > > select date(dttm) dt,max(i) from foo group by dt order by 1; > > > > However, it’s returning only 1 row, with no date column shown. How can I > get an actual “date” listed in the first column, and also get 1 row per > “date” value. > > > > |5283598256 > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
