Varshini S
asked on
How to filter the records in the SQL query ?
http://sqlfiddle.com/#!3/dc7d4/2
I do not want to display code ='BBB'. Where to add this condition in the following query ?
SELECT
t1.City,t1.code
, count(distinct title) as [Title Count]
, max(ca1.notes) as "City[No of book Sold]"
, sum(NumSold) as [NO OF BOOK SOLD]
FROM Table1 as t1
CROSS APPLY (
SELECT
STUFF((
SELECT
', ' + t2.Title + '[' + convert(varchar,t2.NumSold
FROM Table1 AS t2
WHERE t2.City = t1.City
AND t2.code=t1.code
ORDER BY t2.NumSold DESC, t2.Title
FOR XML PATH ('')
)
, 1, 1, '')
) ca1 (Notes)
GROUP BY
t1.City,t1.code
ORDER BY
count(distinct title) DESC
, sum(NumSold) DESC
, City
;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.