Home > mailing lists

Re: select top N entries from several groups - Mailing list pgsql-novice

From	Reinhard Hnat
Subject	Re: select top N entries from several groups
Date	April 12, 2005 13:53:51
Msg-id	002901c53f67$0a7a8470$0163a8c0@hnat Whole thread Raw
In response to	select top N entries from several groups (David Orme <d.orme@imperial.ac.uk>)
List	pgsql-novice

Would you like:

INSERT INTO finaltable SELECT gp, val FROM temp where gp = 'A' ORDER BY val
DESC LIMIT 2;

best regards
R.Hnat

From: Sean Davis
Date: 12 April 2005, 12:21:42
Subject: Re: select top N entries from several groups

From: David Orme
Date: 12 April 2005, 14:29:25
Subject: Re: select top N entries from several groups (Modified by David Orme)