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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-19 : 17:48:31
|
Martin writes "Using a single SQL Statement
Single table containing 40 rows
There are 40 Foreign Key Values
I want a count of the distinct FK values i.e
The are 10 distinct clients records in the table
client 1 has 2 FK values
Client 4 has 4 FK values
etc up to 10 distinct FK values
You get this there a beer in the post for you." |
|
|
|
|
|
Count in SQL