Hello all,
I am trying to get a total number of rows returned form a query.
SELECT count(this) from table group by this
Currently it is returning x rows with a count of each of the group by.
I need the count of the rows returned!
Any way to do this?
----------
UMPA
Brian C. Doyle
Director, Internet Services
United Merchant Processing Association
<http://www.umpa-us.com> http://www.umpa-us.com
1-800-555-9665 ext 212 5 2042
Dev wrote: Hello all,
I am trying to get a total number of rows returned form a query.
SELECT count(this) from table group by this
Currently it is returning x rows with a count of each of the group by.
I need the count of the rows returned!
SELECT COUNT(DISTINCT this) FROM table
Andre
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)
* Dev <de*@umpa-us.com> [2004-10-14 16:54:56 -0400]: I am trying to get a total number of rows returned form a query.
SELECT count(this) from table group by this
Remove the 'group by' clause -- you don't need it.
--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
How about ...
select count(distinct this) from table
John Sidney-Woollett
Dev wrote: Hello all,
I am trying to get a total number of rows returned form a query.
SELECT count(this) from table group by this
Currently it is returning x rows with a count of each of the group by.
I need the count of the rows returned!
Any way to do this? ----------
UMPA Brian C. Doyle Director, Internet Services United Merchant Processing Association <http://www.umpa-us.com>http://www.umpa-us.com 1-800-555-9665 ext 212
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)
Thank you all who helped me out on this..
I had tried the distinct but not inside the count.
I was using the group by because this could have multiple returns but after
adding the distinct to inside the count it worked like a charm!!!
Thanks to everyone who helped out on this one!
At 05:01 PM 10/14/2004, Dev wrote: Hello all,
I am trying to get a total number of rows returned form a query.
SELECT count(this) from table group by this
Currently it is returning x rows with a count of each of the group by.
I need the count of the rows returned!
Any way to do this? ---------- Brian C. Doyle Director, Internet Services United Merchant Processing Association <http://www.umpa-us.com>http://www.umpa-us.com 1-800-555-9665 ext 212
----------
UMPA
Brian C. Doyle
Director, Internet Services
United Merchant Processing Association
<http://www.umpa-us.com> http://www.umpa-us.com
1-800-555-9665 ext 212 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: brendonlam |
last post by:
Hi there,
Hoping someone could advise me here pls; I'm creating a C# class that
implements a telnet client socket allowing a VB . NET application to
communicate with telnet servers. After leaving the app running for just 6
hrs, the thread count exploded to close to 1000, before the app finally stops
responding. The handles probably hit close to 10000.
Tracing my code, I isolated the leak to when I execute a telnet command.
Everytime I...
|
by: desi90 |
last post by:
Hi,
I have a following report created from a table
REGION Issue count
South C1 3
South C2 1
West C1 4
North C1 2
North C2 5
East C1 1
|
by: G Patel |
last post by:
Hi, I'm wondering if anyone knows if the following function will
function properly as a set-bit counter on non 2s complement machines
(as K&R2 implies).
| int bitcount(unsigned x)
| {
| int count;
|
| for(count = 0; x != 0; count++, x &= (x-1))
| ;
|
by: Matthew Groch |
last post by:
Hi all,
I've got a server that handles a relatively high number of concurrent
transactions (on the magnitude of 1000's per second). Client
applications establish socket connections with the server. Data is
sent and received over these connections using the asynchronous model.
The server is currently in beta testing. Sporadically over the course
of the day, I'll observe the thread count on the process (via perfmon)
start climbing....
|
by: Volkan |
last post by:
Hi,
I'm trying to compare two XML documents and i'm using XPath queries to
select nodes. XPathNavigator's Select method runs fast enough and
returns an XPathNodeIterator object. When i try to access this
iterator's Count property the process extremely slows down. If i just
iterate throgh 18.000 nodes and call XPathNavigator.Select to find
equivalent node from the other document it doesn't even take 1 second.
But in the same loop, when i...
| |
by: sharijl |
last post by:
I have a SQL query which returns the total amount of issues:
SELECT issue,Count(issue) as total FROM mytable Group by issue
This works but I need the total of the same catagory in three tables so I assumed a union would work so tried something like this:
SELECT issue,Count(issue) as total FROM mytable Group by issue
Union
SELECT issue,Count(issue) as totalFROM mytable2 Group by issue
union
|
by: cmartin1986 |
last post by:
I have written a sql query and I need it to return 0 when it doesn't find any matches to my criteria. I have tried adding iif statements, tried sum, and just Count, all of these methods work fine to return the values when it finds matches, but i need it also to return a 0 when there are no matches. Here is what I got.
SELECT "CAL Recieved" as Tags, .,sum(iif(.,1,0)) AS
FROM
GROUP BY .
HAVING (((.)=(Date()-1)));
UNION ALL
SELECT...
|
by: Chad Scharf |
last post by:
Ok, as silly as it may sound, I have a situation where I am creating a
CompositeControl in ASP.NET 2.0, C#. I have the following code in the
CreateChildControls() method that build the control's child control
collection:
for (int i = 0; i < _menus.Count; i++)
this.Controls.Add(_menus);
foreach (FloatingMenu menu in _menus)
{
|
by: KingofGing |
last post by:
Hi All,
I'm having a problem writing an SQL statement that I can't quite wrap
my head around.
First, the background:
I have a journal subscription system including 3 tables,
tblSubscription, tblTransaction and tblIssue, detailed below.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |