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
5  965 
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
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
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
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
>
>
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
> >
> >
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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
|
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:...
|
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...
|
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...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
|
by: tracyyun |
last post by:
Hello everyone,
I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
|
by: giovanniandrean |
last post by:
The energy model is structured as follows and uses excel sheets to give input data:
1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
|
by: NeoPa |
last post by:
Hello everyone.
I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report).
I know it can be done by selecting :...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)
Please note that the UK and Europe revert to winter time on...
|
by: nia12 |
last post by:
Hi there,
I am very new to Access so apologies if any of this is obvious/not clear.
I am creating a data collection tool for health care employees to complete. It consists of a number of...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
|
by: isladogs |
last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, Mike...
| |
