468,107 Members | 1,325 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

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

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
Nov 20 '05 #1
5 828
Is this for homework?
"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:eT**************@TK2MSFTNGP10.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

Nov 20 '05 #2
I am not very confortable with SQL...and that's why i sent the post.
....but i can allways give you lessons of Actionscript, Flash, Genetic
Alghoritms, Fuzzy Control and so on...

Cheers,
Miguel
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:#s**************@TK2MSFTNGP09.phx.gbl...
Is this for homework?
"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:eT**************@TK2MSFTNGP10.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


Nov 20 '05 #3
I understand that. I have no problem helping you with homework, but I just
want to make sure you learn it...

post your sql and we'll take a look at it...
"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:u4**************@TK2MSFTNGP09.phx.gbl...
I am not very confortable with SQL...and that's why i sent the post.
...but i can allways give you lessons of Actionscript, Flash, Genetic
Alghoritms, Fuzzy Control and so on...

Cheers,
Miguel
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:#s**************@TK2MSFTNGP09.phx.gbl...
Is this for homework?
"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:eT**************@TK2MSFTNGP10.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



Nov 20 '05 #4
Don't worry God...there was somebody more humble than you which allready
helped me...

Cheers,
Miguel

"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:Op**************@TK2MSFTNGP10.phx.gbl...
I understand that. I have no problem helping you with homework, but I just want to make sure you learn it...

post your sql and we'll take a look at it...
"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:u4**************@TK2MSFTNGP09.phx.gbl...
I am not very confortable with SQL...and that's why i sent the post.
...but i can allways give you lessons of Actionscript, Flash, Genetic
Alghoritms, Fuzzy Control and so on...

Cheers,
Miguel
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:#s**************@TK2MSFTNGP09.phx.gbl...
Is this for homework?
"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:eT**************@TK2MSFTNGP10.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
>
>



Nov 20 '05 #5
Well good for you.

"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:ec**************@TK2MSFTNGP10.phx.gbl...
Don't worry God...there was somebody more humble than you which allready
helped me...

Cheers,
Miguel

"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:Op**************@TK2MSFTNGP10.phx.gbl...
I understand that. I have no problem helping you with homework, but I

just
want to make sure you learn it...

post your sql and we'll take a look at it...
"Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
news:u4**************@TK2MSFTNGP09.phx.gbl...
I am not very confortable with SQL...and that's why i sent the post.
...but i can allways give you lessons of Actionscript, Flash, Genetic
Alghoritms, Fuzzy Control and so on...

Cheers,
Miguel
"CJ Taylor" <[cege] at [tavayn] dit commmmm> wrote in message
news:#s**************@TK2MSFTNGP09.phx.gbl...
> Is this for homework?
>
>
> "Miguel Dias Moura" <we****@27NOSPAMlamps.com> wrote in message
> news:eT**************@TK2MSFTNGP10.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
> >
> >
>
>



Nov 20 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by David Ehmer | last post: by
27 posts views Thread by Alex | last post: by
6 posts views Thread by Damon Grieves | last post: by
3 posts views Thread by Andy_Khosravi | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.