[sqr-users] Count of only one instance

["Brooke Funk" <Brooke.Funk@firstfedbankkc.com>]

I am drawing a blank on how to find where only one instance in a table exists.  
There are some accounts that have multiple rows but I am looking for only those 
that have only one row in the table.  I have tried grouping with the count (*) 
= 1 but it is returning accounts that have more than 1 row in it.  Can someone 
help me out?  I can say what I want but in writing it in SQL it's not working.  
I have several other columns from different tables I am pulling but I want only 
those accounts that have only 1 instance in this particular table regardless of 
multiple rows in other existing tables I am pulling from.





NOTICE:  This e-mail is intended solely for the use of the
individual to whom it is addressed and may contain information
that is privileged, confidential or otherwise exempt from
disclosure.  If the reader of this e-mail is not the intended
recipient or the employee or agent responsible for delivering
the message to the intended recipient, you are hereby notified
that any dissemination, distribution, or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please immediately notify us by replying
to the original message at the listed e-mail address.

Thank you.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users