on 2024 May 11 2:44 PM
All,
This is my current SQL Query:
SELECT "Project","Project Name","Labor Budget","Labor Billed","Address1","period","year","month","Calculated_1" From REA
I want to only bring in the DISTINCT Project's so for example as of now it's showing
Project | Project Name | Labor Billed | Labor Budget | Address1 | Period | Year | Month |
1 | Elmers Ave | 171100 | 2550 | 460 Madison Ave | 201501 | 2015 | 1 |
1 | Elmers Ave | 171100 | 3000 | 460 Madison Ave | 201601 | 2016 | 1 |
1 | Elmers Ave | 171100 | 3750 | 460 Madison Ave | 201507 | 2015 | 7 |
I would only want to bring in 1 value for each project number. Is this possible?
Project | Project Name | Labor Billed | Labor Budget | Address1 | Period | Year | Month |
1 | Elmers Ave | 171100 | 2550 | 460 Madison Ave | 201501 | 2015 | 1 |
Request clarification before answering.
User | Count |
---|---|
91 | |
11 | |
9 | |
6 | |
6 | |
4 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.