Hi , Try this out SELECT count(o.id) FROM output_table o , parent_table p WHERE o.pid=p.pid AND o_date < now() GROUP BY p.pid ; On Thu, 13 Dec 2007 10:00:56 +0000 (GMT) Ashish Karalkar <ashish_postgre@xxxxxxxxxxx> wrote: > Hello List member, > I have a table which ha sfollowing structure > > my_table: > ( > output_id serial priimary key, > parent_id int, > output_date timesatmp > ) > > parent_table: > > (parent_id int, > parent desc > ) > > the my_table contains data for previous as well as future output > dates. for single parent there may be multiple rows. > > I want to retrieve all the output_id which are having latest > output_date but less than now() (no future output_dates) group by > parent_id > > Thanks in advance > > With Regards > Ashish... > > > --------------------------------- > Forgot the famous last words? Access your message archive online. > Click here. -- Trinath Somanchi , (trinaths@xxxxxxxxxx), ******************************************************************************** This email message (including any attachments) is for the sole use of the intended recipient(s) and may contain confidential, proprietary and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please immediately notify the sender by reply email and destroy all copies of the original message. Thank you. Intoto Inc. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
