SELECT Ename, MAX(Salary) AS Salary, SUM(Salary) AS Cu_Sal
FROM table
WHERE YEAR(datecolumn) = YEAR(GETDATE())
GROUP BY Ename

DECLARE @table table (Ename varchar(1), Salary int)
INSERT INTO @table
SELECT 'A', 15000 UNION ALL SELECT 'B', 10000 UNION ALL 
SELECT 'C', 20000 UNION ALL SELECT 'D', 45000

SELECT Ename, Salary, Cu_sal = 
  (SELECT SUM(Salary) AS Cu_sal 
    FROM @table b 
    WHERE b.Ename <= a.Ename)
FROM @table a

quote:

---

Originally posted by manthan1980

the query you said for the reverse format will change it for the entire column. Is there way to change it to specific values in the column.

---

quote:

---

Originally posted by manthan1980

can you guide me to write a query to get cumulative salary, like this

Ename Salary Cu_Sal
----- ------ -------
A 15000 15000
B 10000 25000
C 20000 45000
D 45000 90000


Do i need to use functions or can it be done by using a subquery.IF yes please explain


one more doubt.Is there a query to write a word in the reverse format.
for ex:SQL--->LQS

also on the same lines can we write a query to convert the case of the string like for ex:SeRVer---->sErvER

---