futurestar Posted August 9, 2011 Share Posted August 9, 2011 Sample data... TABLE1 sample data: RMANUM SONUM 4799 1634224 4799 1637572 4799 1638972 I want to create a view that selects only one line per RMANUM (the one with with the maximum SONUM) from TABLE1 above, so the result would be: RMANUM SONUM 4799 1638972 How do I accomplish this? Group By? Distinct? Last? I've tried and failed 20 different ways and it's driving me nuts. Thank you in advance! Link to comment https://forums.phpfreaks.com/topic/244359-create-a-view-from-table-that-contains-only-distinct-values/ Share on other sites More sharing options...
DavidAM Posted August 9, 2011 Share Posted August 9, 2011 How about MAX? SELECT RMANUM, MAX(SONUM) AS maxSONUM FROM TABLE1 GROUP BY RMANUM Link to comment https://forums.phpfreaks.com/topic/244359-create-a-view-from-table-that-contains-only-distinct-values/#findComment-1255073 Share on other sites More sharing options...
futurestar Posted August 9, 2011 Author Share Posted August 9, 2011 THANK YOU FOR HELPING A TOTAL NEWB! Link to comment https://forums.phpfreaks.com/topic/244359-create-a-view-from-table-that-contains-only-distinct-values/#findComment-1255076 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.