I wanted to know if there is any way to write a query which can provide multiple attribute snapshot & summary data in 1 go.
Please have a look at the transpose value functions within the PI OLEDB Enterprise. This video explains it well: PI SQL - Create transpose functions to customize PI OLEDB Enterprise queries - YouTube
There is also information on the subject in the LiveLibrary
Retrieving data ...