How to find Double Majors

[rg3480]

I have 2 colums, one with the list of all students id number and if they are in a double major their id is listed 2 times in the colum. The next colum is the id of the specific business scholl they are in (accounting, mis...)
How do I find out specifily how many double majors are in mis with accounting or with finance ect. in an SQL statment?


id major code

rt1245 bs223
rt1245 bs224(this person is a double major)
rs235 bs223

[MMcCarthy]

I have 2 colums, one with the list of all students id number and if they are in a double major their id is listed 2 times in the colum. The next colum is the id of the specific business scholl they are in (accounting, mis...)
How do I find out specifily how many double majors are in mis with accounting or with finance ect. in an SQL statment?


id major code

rt1245 bs223
rt1245 bs224(this person is a double major)
rs235 bs223

You haven't explained your requirements very well. I'm afraid I'm confused as to what actual results you want in your query.

[missinglinq]

I agree with Mary that clarification is needed. At first glance, however, it seems you are needlessly complicating things! It is very poor design to have student IDs, which I assume would be your unique identifier for a record, appear twice in a table. With only two majors possible per student, it makes more sense to have a second Major field and a corresponding second field for school of study, in your record.