|
Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
|
|
|
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.
|
- Advertisement - |
|||||||||||||||
FALSE ALARM
Posted - 2006-11-18 : 21:15:05
Gang, I need to add the OZ field to this SQL statement and I just cannot figure how to do this. SELECT SUM(Lbs) AS SumLbs,Max(Oz) as MaxOz,SUM(Oz) AS SumOz,MAX(Lbs) as MaxLbs FROM Fish Where FishId= 232