Re: Show 4 Records that occur more often...and how often they occur.

From: Miguel Dias Moura (web001_at_27NOSPAMlamps.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 15:37:23 +0100

Thanks,

can you tell where can i find the SQL forum?

"avnrao" <avn@newsgroups.com> wrote in message
news:uh1$0a3MEHA.1608@TK2MSFTNGP12.phx.gbl...
> This post should have been in SQL. neway, what required is getting the
> things done..
>
> Select Top 4 AuthorName, Sum(BookTitle) from Table Group By AuthorName
Order
> By Sum(BookTitle) Desc
> check if it works.
>
> Av.
>
> "Miguel Dias Moura" <web001@27NOSPAMlamps.com> wrote in message
> news:eY27ms2MEHA.3016@tk2msftngp13.phx.gbl...
> > Hello,
> >
> > i have a dataSet in an ASP.Net / VB page which connects to a database
> > named
> > "DB" with fields AuthorName, BookTitle, BookEditor.
> >
> > I want do display 4 records in my page as follows:
> > Author Name # Number of books published by this Author (Number of
> > records
> > associated with this Author)
> >
> > I want to display the 4 Authors which published more books...
> >
> > In conclusion:
> > I want to show the 4 AuthorName values which appear more often in the
> > database and display the number of records having that AuthorName.
> >
> > Can you help me out?
> >
> > How should my SQL look? What do i need to add?
> >
> > Thank You,
> > Miguel
> >
> >
>
>

Relevant Pages