Hi David,
can't give you detailed advice but I believe you look for
SELECT...GROUP BY ... ORDER BY
Please see the docs like "info mysql".
Best regards
Nils Valentin
Tokyo/Japan
\
2003年 6月 4日 水曜日 22:37、Dave Terrio さんは書きました:
> Hello - I'm a relative newcomer to development with MySQL and am
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 9:08 AM
To: Mike Hillyer; Dave Terrio; [EMAIL PROTECTED]
Subject: Re: nested ORDER BY statements
Hi,
I am a bit new to mysql but have extensive experience with Oracle.
Does MYSQL allow a select like:
select data1
Hillyer" <[EMAIL PROTECTED]>
To: "Dave Terrio" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, June 04, 2003 4:40 PM
Subject: RE: nested ORDER BY statements
Aah, in that case I am not sure you can do what you need to do with a
single query... A UNION may
Terrio; [EMAIL PROTECTED]
Subject: RE: nested ORDER BY statements
Aah, in that case I am not sure you can do what you need to do with a
single query... A UNION may allow it.
(SELECT * FROM table1 WHERE 1=0)
UNION
(SELECT * FROM table1 ORDER BY table1.time_created DESC LIMIT 50)
ORDER BY table1
to take away
the first select and the union statement, I am not sure.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Dave Terrio [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 8:27 AM
To: Mike Hillyer
Subject: RE: nested ORDER BY statements
Thanks for the
Hi David,
> Hello - I'm a relative newcomer to development with MySQL and am having a
> problem with ordering my query results...
This is a general SQL question. Try this:
... ORDER BY time_created DESC, name LIMIT ...
In general, you can't declare a clause twice, except for the
Drop the second ORDER BY clause in favor of a comma.
ORDER BY table1.time_created DESC, table1.name LIMIT 50
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Dave Terrio [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 7:38 AM
To: [EMAIL PROTECTED]
Subject: nested
