Hi folks,
I am trying to compile a query that does statistics on appointments
based on specific criteria. Here is my starting query:
SELECT
u.user_id,
c.client_id,
c.first_name,
c.last_name,
a.time_start AS stime,
FROM_UNIXTIME(a.time_start,'%Y-%m-%d') AS formatted
For (1), ponder:
Group-by trick example: Find the most populous city in each state:
SELECT state, city, population, COUNT(*) AS num_cities
FROM
( SELECT state, city, population
FROM us
ORDER BY state, population DESC ) p
GROUP BY state
ORDER BY
On 2012-05-17 9:37 AM, Don Wieland wrote:
Hi folks,
I am trying to compile a query that does statistics on appointments
based on specific criteria. Here is my starting query:
SELECT
u.user_id,
c.client_id,
c.first_name,
c.last_name,
a.time_start AS stime,
List is broken, in many ways.
Amongst many of its failures, the two current biggest is:
1/ This lists bounce messages are clueless they do not include the
reject reason
2/ mysql-owner address STILL points to a sun address which of course is
rejected as they no longer host this list.
*sigh*
Am 18.05.2012 02:51, schrieb Noel Butler:
List is broken, in many ways.
Amongst many of its failures, the two current biggest is:
1/ This lists bounce messages are clueless they do not include the
reject reason
which bounce-messages are you meaning?
may it be you mean the stupid
On Fri, 2012-05-18 at 03:40 +0200, Reindl Harald wrote:
Am 18.05.2012 02:51, schrieb Noel Butler:
List is broken, in many ways.
Amongst many of its failures, the two current biggest is:
1/ This lists bounce messages are clueless they do not include the
reject reason
which