Posted by BernsteinVsTheDb on 02/24/06 20:30

Hello all,

I have a table that contains 100+ rows. I'm trying to run a query that
looks like this:
SELECT ..., log10(...) as Rank FROM Table
and the resultset contains only the first row of results.

SELECT ..., log10(...) as Rank FROM Table ORDER BY Rank
returns no results at all!

If you replace log10 with log, it does the same thing. However, if you
replace log10 with abs, it returns exactly what you'd expect, all 100+
rows.

Any thoughts?

Thanks in advance!

• Next in forum: Re: log/log10 functions truncate my resultset
• Prev in forum: median query without using function
• Thread view: log/log10 functions truncate my resultset

[Reply to this message]