Jump to content

Create a view from table that contains only distinct values


futurestar

Recommended Posts

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!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.