Innovative Users Group

You could use the Duplicate Records
report in the Headings Report module if you have the duplicate
check option set to ISBN.

--Karen Perone, Rodman Public Library



On 12/26/2017 4:50 PM, Innovative Users Group wrote:















New Question Posted
Andy Helck
created a new discussion SQL for duplicate
bibs? in Sierra/ Millennium/ Encore
















Hello,

This
is a notification to let you
know that Andy Helck has created
new discussion on the site. You
may find the snippet of the new
discussion below:








In our busy
consortium me sometimes end up
with different libraries adding
bib records for the same exact
ISBN. Does anyone have a simple
query that can pull out duplicate
bib records based on matching the
ISBN numbers? Thanks!



[email]ahelck@telluridelibrary.org[/email]







http://innovativeusers.org/index.php/iug-forum/sierra-millennium-encore/11481-sql-for-duplicate-bibs.html"">Read this discussion











This
email was sent to you, because you have
subscribed to the discussion.

To unsubscribe, please http://innovativeusers.org/index.php/iug-forum.html?controller=subscription&task=unsubscribe&data=dHlwZT1zaXRlDQpzaWQ9Nzc3DQp1aWQ9NzQ5MQ0KdG9rZW49NDdlNzAzNTI1YzM1MzY0MDVhODBmYTBiNDIwMWNhZWU=";">click here.
http://innovativeusers.org/index.php/iug-forum/profile.html#Subscriptions"">Manage
subscriptions.


















flutebrarian@gmail.com

I have this query that I am sure someone else must have posted at some time:

SELECT
content
FROM sierra_view.subfield_view
where marc_tag='020'
group by content
having count(*) > 1;

bbornheimer@sandiego.edu