Hey all
Can anyone tell me the best way to ignore leading whitespace on
orderings?
Thanks
Tim McIntyre
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey all
I would guess this would be a pretty simple question.
How do I select a row whose value for a given column is the greatest
or the least or whatever for that table?
e.g:
select * from table where creation_date > all_other_creation_dates;
Hope that makes some sense. Thanks in advance
up GROUP BY order_id;
Hope that makes some sense?
Again thanks in advance!
Tim
On Dec 7, 2006, at 2:25 PM, mos wrote:
At 03:10 PM 12/7/2006, Tim McIntyre wrote:
Hey all
I would guess this would be a pretty simple question.
How do I select a row whose value for a given column is the greatest
I tried that Peter and for some reason it's still selecting the
oldest date not the newest??? Seems odd? Also I'd really like to
just select id because I'll be using this in a subselect.
Thanks!
Tim
On Dec 8, 2006, at 10:31 AM, Peter Bradley wrote:
Ysgrifennodd Tim McInt
stories s2
WHERE s1.order_id = s2.order_id)
And yes my MAX function does seem to work.
Thanks a ton!
Tim
On Dec 8, 2006, at 10:51 AM, Peter Bradley wrote:
Ysgrifennodd Tim McIntyre:
I tried that Peter and for some reason it's still selecting the
oldest date
