List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 5 2000 11:33pm
Subject:Re: is it possible to select the newest 100 rows
View as plain text  
At 9:19 PM +0100 2000-01-05, Gregor Welters wrote:
>At 16:52 05.01.2000 , Paul DuBois wrote:
>>>Hi!
>>>
>>>I have a table which is updated almost every day. There is a Field 
>>>with a date - but it's varchar.
>>>Now I want to get the newest 100 rows.
>>>
>>>Can someone show me the way how to do this?
>>
>>
>>If you've entered the values in a consistent format, then they should
>>sort in date order.  You can use ORDER BY col_name DESC on that column
>>and LIMIT 100 to pick the first 100 rows of the result.
>
>great, I didn't expect such a simple solution!
>
>now, let me extend the question a bit:
>
>I wan't to know the range of values (minimum and maximum) in a 
>numeric column in this 100 rows,
>and I wan't it in the same query...how can I do that?   (I played 
>with the min() and max()-functions - but it didn't work)


MIN() and MAX() are applied before LIMIT is evaluated.  What you could
do is retrieve the 100 rows into a temporary table, then use MIN() and
MAX() on the contents of the temporary table.

-- 
Paul DuBois, paul@stripped
Thread
is it possible to select the newest 100 rowsGregor Welters5 Jan
  • Re: is it possible to select the newest 100 rowsPaul DuBois5 Jan
    • Re: is it possible to select the newest 100 rowsGregor Welters5 Jan
      • Re: is it possible to select the newest 100 rowsPaul DuBois6 Jan
      • Re: is it possible to select the newest 100 rowshypnos6 Jan
  • Re: is it possible to select the newest 100 rowsEd Carp6 Jan