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 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
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 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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
|
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...
|
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...
| |