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! Quote Link to comment 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 Quote Link to comment 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! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.