quote:

---

Originally posted by kond.mohan

i have written one query for Static report purpose. empname is same for multiple amounts.we need to show the empname for once for different amounts.
report coming ritht now
amar bahadusingh 9000
amar bahadusingh 80
amar bahadusingh 645455
amar bahadusingh 7843

expected format
amar bahadusingh 9000
80
645455
7843

sameple query .
Amar BahadurSingh Nagpur Nagpur Jain Lime & Hardware (L.F) - NSD Wall Putty 261807.00
Amar BahadurSingh Nagpur Nagpur Pyramid Incorporation (L.Finish) - Wall Putty 0.00
Amar BahadurSingh Nagpur Nagpur Shoeb Khan (L.F) - NSD Wall Putty 23850.00
Amar BahadurSingh Nagpur Nagpur SIMON THOMAS VARGHESE Wall Putty 97200.00
Amar BirPalta Hyderabad Hyderabad HO Samples Adhesive 0.00
Amar BirPalta Hyderabad Hyderabad HO Samples Application Tools 0.00
Amar BirPalta Hyderabad Hyderabad HO Samples GROUT 0.00
Amar BirPalta Hyderabad Hyderabad HO Samples LATEX 0.00
Amar BirPalta Hyderabad Hyderabad HO Samples STONE CARE 0.00

---

SELECT
	CASE WHEN RN = 1 THEN [name] ELSE '' END AS [Name],
	Amount
FROM
(SELECT
	[name],[amount],
	ROW_NUMBER() OVER (PARTITION BY [name] ORDER BY amount) AS RN -- order by whatever criteria you want
FROM
	YourTable
)s ORDER BY RN -- or some other criteria