Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sfjtraps
Yak Posting Veteran
65 Posts |
 Posted - 2014-11-20 : 10:00:23
|
| I need to query SQL Server Express 2012 records to find 6 serial numbers that are all assigned to one common unique number. Normally in this use case, 12 serial numbers are assigned to one common unique number, so I'm trying to find the odd entry.Can someone help me build this query please? |
|
|
sfjtraps
Yak Posting Veteran
65 Posts |
Posted - 2014-11-20 : 10:12:46
|
| To clarify, I don't know what that common unique number is. The common unique number is only suppose to have 12 serial numbers assigned to it, but somewhere in a database of about 5000 serial numbers there is a common unique number that has 6 serial numbers assigned to it. |
 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-20 : 11:26:45
|
| Please post your table definition as DDL (i.e. a CREATE TABLE statement) |
|
|
|
|
|
|
Query the quantity of records