I can't find his phone number to call him.
-Original Message-
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Wednesday, August 08, 2012 12:22 PM
To: elim@gmail.com
Cc: mysql@lists.mysql.com
Subject: RE: trouble with perl
I know I had the same problem with PHP when mysql.dll
Try
order by CAST(Balance as decimal(8,2)) asc;
Cast will work in the order by.
Glenn Vaughn
- Original Message -
From: "Keith Clark"
To:
Sent: Tuesday, April 27, 2010 3:52 PM
Subject: order by numeric value
I have the following statement:
select chart_of_accounts.accountname
If all you want is the current week then the query is simple:
SELECT * FROM orders where WEEK(orders.order_date) = WEEK(NOW())
The default is thje day starts on Sunday so the second value is not needed.
WEEK(NOW(),7) is equivalent to WEEK(NOW(),0) - the valid values are 0 - 6.
As for performa
This will work:
select distinct X from a as a
where Y in(25)
and
not exists (select X from a as b where a.X = b.X and b.Y in(24))
- Original Message -
From: "Tim Molter"
To:
Sent: Sunday, December 27, 2009 4:04 PM
Subject: Is there a better way than this?
I'm new to MySQL and I'm
SELECT count(distinct trans_no) from SEARCHES WHERE comp_id=675 and
result='o';
- Original Message -
From: "Richard Reina"
To:
Cc:
Sent: Sunday, December 13, 2009 11:36 AM
Subject: Query help
I was wondering if someone could lend a hand with the following query. I
have table.
- Original Message -
From: "Eric Anderson"
To:
Sent: Tuesday, October 20, 2009 4:05 PM
Subject: Re: Distinct max() and separate unique value
I'm trying to formulate a query on a Wordpress database that will give
me the highest 'object_id' with the highest 'term_taxonomy_id',
somethi
I would try:
select max(object_id), term_taxonomy_id
group by term_taxonomy_id
order by term_taxonomy_id;
max(column) returns a single value so distinct is not needed.
The group by and order by should only have columns thaqt are displayed and
that are not aggregate columns.
- Original Mes
o a count of a specific column .
mysql> select count(*) as 'Count' from logins GROUP BY dawiz
I found my problem - it turned out to be a misconception on my part; I was
using sprintf(buf,"%d", row[i]) if it was a numeric field - this was
printing the address rather than the
