Re: How to list parent's table's attribute via sql without function or trigger?
From: Ban Spam <ban-spam_at_operamail.com>
Date: Sun, 26 Jan 2003 15:08:44 GMT
Message-ID: <Xns930F48FC4B1E9SunnySD_at_68.6.19.6>
>
> Nothing.
>
> But Could you tell me what count(*) and group meant? where can I find
> more examples illustrated these two keywords?
>
> Thanks
>
Date: Sun, 26 Jan 2003 15:08:44 GMT
Message-ID: <Xns930F48FC4B1E9SunnySD_at_68.6.19.6>
johnwu_at_yorku.ca (John) wrote in
news: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
>
Read The Fine Manual at tahiti.oracle.com The SQL Reference Manual Received on Sun Jan 26 2003 - 16:08:44 CET