Re: Select f1, min(f2) ????
From: Thodla Subrahmanyam <tsubrahm_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1996/05/13
Message-ID: <4n80pa$nie_at_eccdb1.pms.ford.com>#1/1
Date: 1996/05/13
Message-ID: <4n80pa$nie_at_eccdb1.pms.ford.com>#1/1
Hai!!
May be you can use the following statement:
SQL> SELECT column1,column2
2 FROM table1
3 WHERE column1 = (SELECT min(column1)
4 FROM table1)
Will give you all the records which have the least value for the column1. Similarly you can use the statement with max. I am using an '=' because the subquery will return only one row. Received on Mon May 13 1996 - 00:00:00 CEST