Re: MYSQL query

John ORourke <[email protected]> Fri, 28 Dec 2007 18:12:37 +0000

Newsgroups	gmane.comp.db.mysql.perl
Message-ID	<[email protected]>

Kiran Annaiah wrote:
> group by visit_time;
>   
That means 'create one result row for each unique value of visit_time' - 
perhaps you wanted to group by pat_id, so you can see the 
max(visit_time) for each unique value of pat_id?

cheers
John


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]