Skip site navigation (1) Skip section navigation (2)

ORDER BY problem

From: Michael Rowan <mike(dot)rowan(at)internode(dot)on(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: ORDER BY problem
Date: 2009-08-15 00:59:43
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
This query selects the most recent advertisement (in table  
wha_listing) for all properties (in table wha_property) and returns  
the sales agency (in table wha_agency), as well as other data.  The  
query works as expected.

SELECT DISTINCT ON (property_id)
property_id, date, wha_property.propnum, wha_street.street_name,  
wha_suburb.suburb_name, wha_agent.first_name, wha_agent.last_name,
FROM wha_listing, wha_agent, wha_agency, wha_property, wha_street,  
WHERE = wha_street.suburb_id
AND = wha_property.street_id
AND = property_id
AND = wha_agent.agency_id
AND = agent_id
AND >= "2009-01-01" ORDER BY wha_listing.property_id, DESC;

I need the resulting list to be sorted by

Can I do this by adding something to this query?


Michael Rowan

11 Kingscote Street
South Australia 5014

tel 618 8240 3993


pgsql-novice by date

Next:From: Tom LaneDate: 2009-08-15 01:09:26
Subject: Re: ORDER BY problem
Previous:From: P. StaringDate: 2009-08-14 21:18:40
Subject: Having trouble installing on Vista

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group