FacebookTwitterLinkedIn
Login / Register

Login / Register

IUG FORUM

Stay always connected!
  1. Andy Helck
  2. Sierra/ Millennium/ Encore
  3. Tuesday, December 26 2017, 02:49 PM
  4.  Subscribe via email
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!

ahelck@telluridelibrary.org
Comment
There are no comments made yet.
Add Comment
Bee Bornheimer Accepted Answer
0
Votes
Undo
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
Comment
There are no comments made yet.
Add Comment
Karen Perone Accepted Answer
0
Votes
Undo
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
Comment
There are no comments made yet.
Add Comment
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,pdf,ppt,pptx,doc,docx,xls,xlsx,,txt,rtf,jrxml
• Remove Upload Files (Maximum File Size: 2 MB)
You may insert polls into your post. The poll would then appear in the post.
Vote Options
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.