Hi ramesh sir,

I am your big fan...

and i know you...

You are working with infoton right...

Vaibhav

Try this

SELECT range , Count FROM

(

SELECT COUNT(CASE WHEN DATEDIFF(dd, createdon, modifiedon) < 1 THEN 1

END) AS '< 1' ,

COUNT(CASE WHEN DATEDIFF(dd, createdon, modifiedon) > 1

AND DATEDIFF(dd, createdon, modifiedon) <=...

Yes paul you understood....

because over the internet a lot of material is available but its hard to get the best example sorry example which can easily differentiate the things to...