I have a table where patient visits are logged each visit, the table is:
patientnumber,visitdate,location
I need to select and count the number of records that have 2 or more entries
with the same patientnumber
in sql-english:
select count(*) where there are two or more records with the same
patientnumber
Any help with the SQL to do this would be much appreciated. Thanks!
Jon
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php