Re: How to list parent's table's attribute via sql without function or trigger?
From: John <johnwu_at_yorku.ca>
Date: 26 Jan 2003 06:52:10 -0800
Message-ID: <1673c1fd.0301260652.2b4ff3a4_at_posting.google.com>
Date: 26 Jan 2003 06:52:10 -0800
Message-ID: <1673c1fd.0301260652.2b4ff3a4_at_posting.google.com>
"Brian E Dick" <bdick_at_cox.net> wrote in message news:<8lDY9.21862$GX4.839107_at_news2.east.cox.net>...
> What is the result of the following query?
>
> select id1, id2, count(*)
> from t1
> group by id1, id2
> having count(*) > 1
>
Nothing.
But Could you tell me what count(*) and group meant? where can I find more examples illustrated these two keywords?
Thanks Received on Sun Jan 26 2003 - 15:52:10 CET