Hi, select max(plus) from (select max(t1.c1) plus from t1 join (Select * from t1) z) z; +-----------+ | max(plus) | +-----------+ | 235 | +-----------+ 1 row in set (0.00 sec)
On Tue, Jun 23, 2015 at 6:21 AM, Justin Swanhart <greenl...@gmail.com> wrote: > Hi, > > You can't use a temp table more than once in a query. > > If you could not use table more than once you could not do self join, or > variety of other things: > select * from a A1 join a A2 on A1.child_id A2.id; > > --Justin > > On Tue, Jun 23, 2015 at 12:17 AM, Benoit Panizzon <benoit.paniz...@imp.ch> > wrote: > >> Hi Kristian >> >> > Maybe try something like this (untested): >> > >> > SELECT * >> > FROM (SELECT mail_out_anon+mail_out_auth ss, timeslice >> > FROM domaincounters >> > WHERE domain_id=19 >> > ORDER BY timeslice desc >> > LIMIT 24) tmp >> > ORDER BY ss DESC >> > LIMIT 1; >> >> Thank you, that is the solution I was looking for. >> >> Justin, you cannot have a subquery on the same table within your query. My >> previous attempt was to return the ID's of the last 24 timeslices in a >> subquery and then MAX() them. But MariaDB prevents this kind of query. >> >> Mit freundlichen Grüssen >> >> Benoit Panizzon >> -- >> I m p r o W a r e A G - >> ______________________________________________________ >> >> Zurlindenstrasse 29 Tel +41 61 826 93 07 >> CH-4133 Pratteln Fax +41 61 826 93 02 >> Schweiz Web http://www.imp.ch >> ______________________________________________________ >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
