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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to search number with in a series. 5
Sounds like query 4
Ask not 8
Creating worksheets 1
Creating different worksheets from a main worksheet 3
Office products should include tools to help manage acronym lists 2
query for latest course 1
Nvidia's 'NV60' (GT300) apparently uses MIMD architecture to take onIntel's Larrabee and any other 3

Back
Top