I'm running SQL Server 2012 Verision 11

Thank you and I will make sure to reply better next time.

Hi Luis, Thanks for responding so quickly. I tried using top 1 however it didn't return the results expected. I've attached a *.png file to show what the data in...

Hi, Thanks for responding so quickly. I tried using top 1 however it didn't return the results expected. I've attached a *.png file to show what the data...

thanks for all the help guys.

Ok...so, basically I am trying to count the id's by course_id using the over partition by function.

select distinct l27_mfyp_crs_id "CRS_ID", l27_mfyp_crs_pair1 "COURSE_1" , L27_MFYP_CRS_PAIR1_DESC "COURSE_1_TITLE",

...

Thanks for your help....I understand.