How to get Max value from a column?

[Adem Akus]

create view vw_www
as
select c.customerID,co mpanyname,SUM(o d.OrderID)as ToplamSatis from [Order Details] od inner join Orders o on o.OrderID=od.Or derID
inner join Customers c on c.CustomerID=o. CustomerID
group by c.customerID,Co mpanyName

---i want to get max value of sum.

[gpl]

try this

CREATE VIEW vw_www 
AS 
  SELECT *, 
         MAX(toplamsatis) AS maxtoplamsatis 
  FROM   (SELECT c.customerid, 
                 companyname, 
                 SUM(od.orderid)AS toplamsatis 
          FROM   [Order Details] od
                 INNER JOIN orders o 
                   ON o.orderid = od.orderid 
                 INNER JOIN customers c 
                   ON c.customerid = o.customerid 
          GROUP  BY c.customerid, 
                    companyname) a