Thank U anthony,

Its working...

Is there any alternate syntax/query to get the above result.

i mean without using above code i want to generate the same output...