Re: Need help with SQL Query

why don't you try it and see?  (altho I suspect that using 'count' as the 
result field name might not work, and that having column names with spaces 
in them will require quotes around them.)
"Rikin Parekh" <[email protected]> wrote in message 
news:CALbBjtc3S51Wm=GfZz6_mUW08iRfTC1v=MrzhQru3HX__u2R7A@mail.gmail.com...
> Suppose I have a *BOOKS* table like the one given below:
>
>     ISBN   |  Book Title  |  Author Name
>
>      1           Jungle book    Sam
>      2           Princess Diary  Joe
>      3           Titanic              Sam
>      4           House              Joe
>      5           Scary Movie     Rick
>      6           Wonders          Harry
>      7           Java               Rick
>
>
> I am trying to write a query which will give the *total number of book
> titles written by each author*. The final result should be like
>
> Author Name        Count
>  Sam                    2
>  joe                       2
>  Rick                    2
>  Harry                  1
>
> Can someone help me with this ?? I have tried
>
> Select Author Name, COUNT(Book_Title) as Count
> From Books
> Group By (Author Name)
>
> Will this above query work fine and give the results as shown?
>
> Thank you in advance
>
> Rikin
> 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php