Home -> Usenet -> comp.databases.oracle -> self-join

self-join

From: Sanjin <sanjin.m_at_SoftHome.net>
Date: Tue, 9 Jul 2002 01:28:23 +0200
Message-ID: <agd78s$4v3h$1_at_as201.hinet.hr> 






I.e., I have the data that is returned from the following statement 'SELECT
table1.id, MAX(table1.num) FROM table1 GROUP BY table1.id'



i.e.


table1.id | (MAX(table1.num)

1               3
2               3
3               5
4               1





I want to use returned data like a filter for the retrieving the other data
(columns) from the same table ('table1') (data that matches criteria
returned from the first statement).



Is it possible to achieve that in one sql statement? I have thought to use
self-join.



Thanks in advance



Sanjin
Received on Tue Jul 09 2002 - 01:28:23 CEST












Original text of this message