From: Abdul Wahab Dahalan <wahab@mimos.my>
To: pgsql-sql@postgresql.org
Subject: How to get Rows Count
Date: Mon, 01 Mar 2004 10:06:25 +0800
Message-ID: <40429AA1.4060905@mimos.my> (raw)
>
>
>a b d c
>01 02 b *
>01 02 a *
>02 03
>02 04 b *
>02 04 a *
>03 05
>04 06
>
If I've a table like above, how do I make a query to get rows count that
doesnt have '*' in it.
Can we have other queries than this : Select count(c) from tablename
where c !='*';
or Select count(c) from tablename where c <> '*';
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: wahab@mimos.my
Subject: Re: How to get Rows Count
In-Reply-To: <40429AA1.4060905@mimos.my>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox