SQL Language (MOSC)

MOSC Banner

Display the first and last record

edited Aug 29, 2010 8:27PM in SQL Language (MOSC) 4 commentsAnswered
Hi, we have a table like below (sorted by Name, Date)

Name        Date             

AA          11-Jan-2001  

AA          21-Sep-2001

AA          10-Dec-2001

AA          01-Mar-2002

BB          21-Jan-2001   BB          30-Sep-2001 BB          19-Nov-2001 BB          01-Apr-2002 We would like to have the report to show the first date and last date by name like Name        First Date     Last Date AA          11-Jan-2001    01-Mar-2002 BB          21-Jan-2001    01-Apr-2002 How can we do this report?  Thanks.   

Veronica

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center