I want the following result
the data i have is this, I have tried every posssible way but could not do it this data is also a result from CTE
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answers Answers and Comments
18 People are following this question.
Which is better? CTEs (common table expressions) or Subqueries?
CASE Statement Within Subquery
Counting matches and finding index
Need outPut in a particular format
Removing Repeated Identical SubQueries From A Query?