select distinct
Post on 03-Nov-2015
212 Views
Preview:
DESCRIPTION
Select Distinct
TRANSCRIPT
select distinct(e.subject_code),s.subject_name,s.branch_code from SUBJECT_MASTER s,EXTERNAL_MARKS e where e.SUBJECT_CODE = s.SUBJECT_CODE and e.SEMESTER = s.SEMESTER ande.MONTH = 'apr' and e.YEAR = '2015' and e.PROCESS_TYPE = 'RV' and COURSE_CODE = 'btech' and e.SEMESTER = 8order by e.SUBJECT_CODE
top related