Show Query Output in Single Row
I have a table that records each time the price of a job is created or subsequently amended, eg:
Id JobId Rate
1 100123 90.00
2 100123 85.00
3 100123 75.00
4 100124 80.00
5 100124 85.00
6 100125 90.00
I want to report on is the highest and lowest rates per job, so:
Required output:
JobId HighestRate LowestRate
100123 90.00 75.00
Any help would be appreciated!
Thanks
lapchien
100124 85.00 80.00
100125 90.00 90.00
Id JobId Rate
1 100123 90.00
2 100123 85.00
3 100123 75.00
4 100124 80.00
5 100124 85.00
6 100125 90.00
I want to report on is the highest and lowest rates per job, so:
Required output:
JobId HighestRate LowestRate
100123 90.00 75.00
Any help would be appreciated!
Thanks
lapchien
100124 85.00 80.00
100125 90.00 90.00
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server 2008
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
