Re: Unique Records
From: James Goodwin (jim.goodwin_at_midmichigan.org)
Date: 01/05/05
- Next message: *** mus: "newbie, @@error does not seem to work"
- Previous message: Louis Davidson: "Re: Best way to keep track of SQL server modifications"
- In reply to: Khurram Chaudhary: "Unique Records"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 5 Jan 2005 15:13:27 -0500
"Khurram Chaudhary" <khurram@rogers.com> wrote in message
news:evvt7Yq8EHA.4072@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I want to return a result that shows only the records that are unique in a
> particular field. For example:
>
> ISBN Title
> 112 Microsoft XP
> 112 Microsoft XP (Softcover)
> 113 Windows NT
> 114 Windows 2000
>
> Any suggestions?
1. You may want to review your data model. Softcover is not part of the
Title of that book, it is a media for that book.
2. I'm pretty sure that the Hardcover and Softcover editions of a book have
different ISBN numbers, I'm also sure that ISBN numbers are 10 characters
long including a check digit.
3. Select ISBN, Min(Title) from TableName group by ISBN
- Next message: *** mus: "newbie, @@error does not seem to work"
- Previous message: Louis Davidson: "Re: Best way to keep track of SQL server modifications"
- In reply to: Khurram Chaudhary: "Unique Records"
- Messages sorted by: [ date ] [ thread ]
