fnds Posted March 13, 2009 at 03:55 PM Report Share #250555 Posted March 13, 2009 at 03:55 PM Boas! Eu tenho uma tabela que tem duas colunas numéricas, o que eu queria fazer era uma query que retorna-se o maior valor das duas juntas. Eu qeria fazer algo deste género (isto dá erro...): SELECT max( SELECT max(`c1`) as numero from `tabela` WHERE `id`=46 UNION SELECT max(`c2`) as numero from `tabela` WHERE `id`=46 ) A parte do meio funciona, agora quando ponho o max() de fora não :s Link to comment Share on other sites More sharing options...
Betovsky Posted March 13, 2009 at 04:15 PM Report Share #250558 Posted March 13, 2009 at 04:15 PM Estás quase lá 😉 Select max(numero) From ( Select max(`c1`) as numero from `tabela` WHERE `id`=46 UNION Select max(`c2`) as numero from `tabela` WHERE `id`=46 ) as t "Give a man a fish and he will eat for a day; Teach a man to fish and he will eat for a lifetime. The moral? READ THE MANUAL !" Sign on a computer system consultant's desk Link to comment Share on other sites More sharing options...
fnds Posted March 13, 2009 at 04:21 PM Author Report Share #250561 Posted March 13, 2009 at 04:21 PM Incrivel, eu á pouco não consegui por causa do "as t", dava um erro qualquer 🙂 Tks Betovsky, vê lá se voltas a aparecer no IRC 😉 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now