2011/04/08 17:12 -0400, Michael Dykman
Mildly surprised this is working at all. Your name alias fields like
When should be quoted by back-tics, no double quotes.. this is a
clarification and does not solve the issue really although it might
make your final result less surprising.
A key thing
Once more I am surprised by the ordering that I get from 'GROUP BY'.
This defines the table of directors that have been on the board:
CREATE TABLE DIRECTOR
( Chosen DATE NOT NULL
, Through DATE NOT NULL
, MemberIDINTEGER REFERENCES MemberAddress (MemberID)
,
Mildly surprised this is working at all. Your name alias fields like
When should be quoted by back-tics, no double quotes.. this is a
clarification and does not solve the issue really although it might
make your final result less surprising.
A key thing to note about GROUP BY is that, although
ORDER BY SentDate DESC
Ben Holness wrote:
Hi all,
I have a table with three columns:
Destinationvarchar(254)
SentDate timestamp(14)
UserID varchar(32)
I want to be able to get a list of the 100 most recently used numbers, based
on the timestamp (SentDate)
Hi all,
I have a table with three columns:
Destination varchar(254)
SentDatetimestamp(14)
UserID varchar(32)
I want to be able to get a list of the 100 most recently used numbers, based
on the timestamp (SentDate) column.
I want to have them ordered such