Re: Is relational theory irrelevant? (was Re: Dreaming About Redesigning SQL)

"Bob Badour" <bbadour_at_golden.net> wrote in message news:sZqdnURpMcikvzKi4p2dnA_at_golden.net...
> "Mikito Harakiri" <mikharakiri_at_yahoo.com> wrote in message
> news:bdf69bdf.0311092059.7fa5b13f_at_posting.google.com...
> > "Bob Badour" <bbadour_at_golden.net> wrote in message
> > > Express a quota query.
> >
> > select top 5 * from (
> > select * from emp order by sal
> > )
> >
> > What is the problem, besides "5*from" looking ugly?
>
> The ordered operand.

OK. Then

select EX.EMP#
from EMP EX
where (select count(1)

        from EMP EY
        where EY.HEIGHT < EX.HEIGHT) < 5