n before the table names?
> Is that something DBMS specific?
> A.
> - Original Message -
> From: "Chris Stallo" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, July 19, 2002 7:44 AM
> Subject: Re: [KCFusion] SQL brain teaser
>
>
>
Subject: Re: [KCFusion] SQL brain teaser
> I set up two tables. #tmp_cat contains a cat_number
> and category description. #tmp_question contains a
> cat_number and the question. cat_number is the
> relationship between the two.
>
> The thing that helps is the TOP command i
I set up two tables. #tmp_cat contains a cat_number
and category description. #tmp_question contains a
cat_number and the question. cat_number is the
relationship between the two.
The thing that helps is the TOP command in SQL. It
returns the TOP N rows back.
select category,
c
(is this thing on?)
So I ran accross a problem the other day, solved it, but it is not the most
elegant solution I think. If anybody sees something cleaner right off I'd
much apprciate a reply. If not I would not attempt this while you are at
work.
The problem: We have knowlege base that is org