Upload File

Download - 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

THE DISTINCT EFFECTS OF INFORMATION …worldmanagementsurvey.org/wp-content/images/2010/07/The-Distinct...THE DISTINCT EFFECTS OF INFORMATION TECHNOLOGY AND ... The distinct effects
THE DISTINCT EFFECTS OF INFORMATION …worldmanagementsurvey.org/wp-content/images/2010/07/The-Distinct...THE DISTINCT EFFECTS OF INFORMATION TECHNOLOGY AND ... The distinct effects
Silencioso DISTINCT!
Silencioso DISTINCT!
Horror (DISTINCT)
Horror (DISTINCT)
Introduction to SQL - · PDF fileIntroduction to Oracle ... • List in alphabetic order the names of all instructors select distinct name ... from country where capital is null
Introduction to SQL - · PDF fileIntroduction to Oracle ... • List in alphabetic order the names of all instructors select distinct name ... from country where capital is null
Publishing and sharing historical data on the semantic … · SELECT DISTINCT as1.cle_objet_associe 'idActeur', as1.libelle_calcule_objet_associe 'nom', ... [rapporté par la lettre
Publishing and sharing historical data on the semantic … · SELECT DISTINCT as1.cle_objet_associe 'idActeur', as1.libelle_calcule_objet_associe 'nom', ... [rapporté par la lettre
17 - Hydraulic - Hydraulic.pdfEaton engineering has once again raised the bar. Select Eaton Aeroquip hydraulic hoses offer distinct advantages in three areas, which exceed all SAE
17 - Hydraulic - Hydraulic.pdfEaton engineering has once again raised the bar. Select Eaton Aeroquip hydraulic hoses offer distinct advantages in three areas, which exceed all SAE
 · Web viewDisplay all managers from the table. (manager id is same as emp id) SELECT empname FROM employee WHERE (empid IN (SELECT DISTINCT mgrid FROM employee)) Write a Select
 · Web viewDisplay all managers from the table. (manager id is same as emp id) SELECT empname FROM employee WHERE (empid IN (SELECT DISTINCT mgrid FROM employee)) Write a Select
SQL-QUERIES - Bhavin Patel€¦  · Web viewSQL-QUERIES. Display all the information of the EMP table? ANS) select * from emp; Display unique Jobs from EMP table? ANS) select distinct
SQL-QUERIES - Bhavin Patel€¦  · Web viewSQL-QUERIES. Display all the information of the EMP table? ANS) select * from emp; Display unique Jobs from EMP table? ANS) select distinct