Re: SQL group select question - Mailing list pgsql-sql

From Ramakrishnan Muralidharan
Subject Re: SQL group select question
Date
Msg-id 02767D4600E59A4487233B23AEF5C59922C28F@blrmail1.aus.pervasive.com
Whole thread Raw
List pgsql-sql
Hi,

The following SQL query will fetch you result based on the example given below,

SELECT T.ID , T.VALUE FROM ( SELECT MAX( NUMB ) AS NUMB , NAME  FROM TEST3 GROUP BY NAME ) AS A , TEST3 T
WHERE A.NAME = T.NAME AND A.NUMB = T.NUMB
ORDER BY T.ID DESC

Regards,
R.Muralidharan



pgsql-sql by date:

Previous
From: "Dan Feiveson"
Date:
Subject: Re: tsearch2
Next
From: Veronica L Bounmixay
Date:
Subject: Coming from Oracle SQL