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 |
|
sharonchapman
Starting Member
35 Posts |
 Posted - 2001-09-28 : 13:57:23
|
| I'm creating a view from a table. The view will have four fields: ID, Project Number, Job Number and Sum(Service Cost).The data looks like this:Project # Job Number ID Sum(Service Cost)102 5 1 22.95103 6 2 33.22103 6 3 0.0104 7 4 5.22Since I can't use Distinct in a view, how do I get the view to only select the first 103 project number? |
|
|
|
|
|
Creating Views and Distinct