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.