How to query this?

  • Thread starter Thread starter Song Su
  • Start date Start date
S

Song Su

I want a uniq MajorCode with only latest AcadYear with MajorDescription.

Thanks.

AcadYear MajorCode MajorDescription
20082009 000300 Undecided
20092010 000300 Undecided
20072008 012080 Medical Assistant
20082009 012080 Medical Assistant
20092010 012080 Medical Assistant
20002001 020100 Architectural Computer Aided Design/Drafting
20012002 020100 Architectural Computer Aided Design/Drafting
20032004 020100 Architectural Computer-Aided Design- AutoCAD
20042005 020100 Architectural Computer-Aided Design- AutoCAD
 
Select MajorCode,
MajorDescription,
Max(AcadYear),
From YourTable
Group By MajorCode,
MajorDescription ;

This might not be exactly what you need as it could come up with more than
one MajorDescription.
 
Back
Top