How to get Rows Count

From: Abdul Wahab Dahalan <wahab(at)mimos(dot)my>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to get Rows Count
Date: 2004-03-01 02:06:25
Message-ID: 40429AA1.4060905@mimos.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
>
>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 <> '*';

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Chaney 2004-03-01 03:17:16 Re: User defined types -- Social Security number...
Previous Message Joe Conway 2004-02-29 23:35:57 Re: Trouble with composite types