Re: Simple SQL Question

On Sun, 19 Apr 1998 15:02:17 -0400, Suresh Easwar <sje_at_sigma-inc.com> wrote:

>If the count(*) column in the output bothers you, use:
>create view v_emp as
> select a.ename ename, a.sal sal, count(*) rank
> from emp a, emp b
> where a.sal <= b.sal
> group by a.ename, a.sal
>

Why not simply not include the COUNT(*) column in the SELECT clause?

Nuno Guerreiro Received on Mon Apr 20 1998 - 04:28:59 CDT