473,323 Members | 1,570 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

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 975
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: David Ehmer | last post by:
The code below is 2 rows in a table, the top row contains a message to be shown if the recordset returns no matches. The 2nd row will display any matches. Problem is that if no matches are found...
6
by: asad | last post by:
Hi, i have some problem in showing data. I have two tables First table(containing Hosting categories) Second table(Containg catagories data lik url,keyword,description.....etc) I want to...
8
by: mgm | last post by:
hello, I have a query that is supposed to return only 1 record, however I recently found that because of an error in the database it can return more than 1. So what I need to do is capture if it...
5
by: Rob Ristroph | last post by:
Hi, It's pretty unhelpful to post "I have a huge piece of code that crashes in strange places, what's the problem?" but that's basically my problem and I really am at my wit's end. The piece...
27
by: Alex | last post by:
Hi, MySQL has a nice feature that allows to call a replace rather insert which will attempt to insert if record not present and replace if it does. Is there any similar feature ? Currently I...
6
by: Damon Grieves | last post by:
Hi I just want to be sure I understand how the Access client works. If I have an Access back end with a million records on a server and an Access client. If the client is installed on the users pc...
15
by: Hi5 | last post by:
Hi, I am designing a database for a client in which It has a client table including the followings: 1-Table Client 2-Table lookupcategory 3-Table Ctegory
4
by: Miguel Dias Moura | last post by:
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:...
5
by: JSParker1 | last post by:
Summary: Maximum number of records per second that can be inserted into SQLServer 2000. I am trying to insert hundreds (preferably even thousands) of records per second in to SQLServer table...
3
by: Andy_Khosravi | last post by:
I'm having a problem with an entry form on one of my applications. It would appear that the save action is sometimes not working, and is generating no error when it fails. I'm hoping one of you may...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.