hi ,

i have a Table with book id,book publishing date.

i need to dispaly the count of the book in this format:-

Book Id Aug-1 Aug-2
b1 4 5
b2 4 5
b3 5 5
b4 9 15
b5 12 16

let me know the select statement to be used for adding the columns dynamically till the date i have in the column book publishing date.