Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get Only Records With Sequence = 1
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01397692
Message ID:
01397696
Vues:
52
>I have a table of part information. The combination of PartNo and SerialNo make the row unique. There is a Sequence column.
>I want to get back all records where there is only one record for PartNo/SerialNo combination. I'm not sure what the syntax
>for this query is. Can someone help?

Not sure what you want, could you please post some data and desired result from it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform