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

  • Thread starter Thread starter Miguel Dias Moura
  • Start date Start date
M

Miguel Dias Moura

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
 
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
 
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...
 
Don't worry God...there was somebody more humble than you which allready
helped me...

Cheers,
Miguel
 
Well good for you.

Miguel Dias Moura said:
Don't worry God...there was somebody more humble than you which allready
helped me...

Cheers,
Miguel

CJ Taylor said:
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 said:
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
Is this for homework?


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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top