Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mItSV-0007P9-03 for pgsql-novice@arkaria.postgresql.org; Wed, 25 Aug 2021 14:00:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mItST-00054i-NC for pgsql-novice@arkaria.postgresql.org; Wed, 25 Aug 2021 14:00:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mItR4-0001vo-Nn for pgsql-novice@lists.postgresql.org; Wed, 25 Aug 2021 13:59:22 +0000 Received: from esa06.ucs.mun.ca ([134.153.136.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mItQx-0003Xk-JC for pgsql-novice@postgresql.org; Wed, 25 Aug 2021 13:59:19 +0000 IronPort-SDR: bLbVcbbQ5Y8rO1v2FrqMTCFb0IM8/q7BtYOiG3HMuS0sKT0H77gqJHVbuy0QVXY8QuewFtuq92 i/5oFLOK7GgniuLKPVvio0nAuqoNgb3X2+I3b2jAqSVGggnJqAHoKVlNUlMQWumTKWdyHqc56z yU0nNMjGxPkJBIpqnwedYCWPZXizcrIQrYWfyyhXJkN8lyN1obGhZshmWL/32J7EoJV6OiRJMH kzbT+cZQ2UbaZdhonRR4dZ4B8q5Lb29zFa29YTTs9kmy2hRCAUnEhUTeDFq1F/gsgmMnfwuroH 0xY= IronPort-HdrOrdr: =?us-ascii?q?A9a23=3An0Q6rKPj3gxwzcBcTsWjsMiBIKoaSvp037?= =?us-ascii?q?BL7TESdfU7SK2lfqyV8cgz9RixkzoJXWFlhNboAse9qBDnhP1ICOsqXYtKNT?= =?us-ascii?q?OO0FdAbrsI0WKI+VLd8kPFmtJ16b1taOx3BtH2EDFB5/rH3A=3D=3D?= X-IronPort-AV: E=Sophos;i="5.84,350,1620700200"; d="scan'208";a="64612783" X-Amp-Result: SKIPPED(no attachment in message) X-Amp-File-Uploaded: False Received: from cpe00fc8db7a323-cm00fc8db7a320.cpe.net.cable.rogers.com (HELO pyrope.local) ([174.117.202.255]) by smtp06.ucs.mun.ca with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 25 Aug 2021 11:29:12 -0330 References: User-agent: mu4e 1.5.6; emacs 27.2 From: Roger Mason To: pgsql-novice Subject: Re: select from grouped data In-reply-to: Date: Wed, 25 Aug 2021 11:29:10 -0230 Message-ID: MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk David G. Johnston writes: > SELECT DISTINCT ON (jid) jid, timestamp, scf, energy [...] ORDER BY jid, > scf DESC Got it. Many thanks, Roger