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 |
|
Mondeo
Constraint Violating Yak Guru
287 Posts |
 Posted - 2008-02-19 : 08:47:10
|
| SELECT DISTINCT (vehicleref) FROM vwAllMatrixWithLombardAndShortModelThis returns 3711 rows which is correctSELECT DISTINCT COUNT (vehicleref) FROM vwAllMatrixWithLombardAndShortModelGives me 44111How do I get the count from the first statement?Thanks |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2008-02-19 : 08:49:05
|
| SELECT COUNT ( DISTINCT vehicleref) FROM vwAllMatrixWithLombardAndShortModel"God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
|
|
|
COUNT function