Re: Need help with SQL Query
| From: | Jim Giner | Date: | Fri, 13 Apr 2012 13:12:05 +0000 |
| Subject: | Re: Need help with SQL Query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48257@lists.php.net to get a copy of this message | ||
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" <rikin08@gmail.com> 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
>