subject:"\[HACKERS\] select avanced"

Re: [HACKERS] select avanced

2008-02-27 Thread Richard Huxton

[EMAIL PROTECTED] wrote: I have the following table: The hackers list is for development of the PostgreSQL database itself. Please try reposting on the general or sql mailing lists. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- T

[HACKERS] select avanced

2008-02-27 Thread cristianopintado

I have the following table: Objeto Valor ob1 10 ob1 20 ob2 50 ob2 10 ob3 50 With the following command: "select distinct Objeto, sum(valor) from tb group by Objeto;" I have to return: Objeto Valor ob1