Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Example to display records of student pass in all subjects and marks are greater than 60 in maths

Posted By: Rhys Evans     Category: Oracle     Views: 5157

This article provides an example to display records of student pass in all subjects and marks are greater than 60 in maths.

Code for Example to display records of student pass in all subjects and marks are greater than 60 in maths in Oracle

select S.ROLLNO, S.NAME, S.CLASS, S.BIRTHDATE from student S,course C,sc where sc.courseno = C.courseno and sc.rollno = S.rollno and (coursename=’Maths' and marks > 60) and (marks >= 35);

Output :

    ROLLNO NAME            CLASS      BIRTHDATE
---------- --------------  ---------- ---------

         1 Mikki Raval     A          20-MAR-84
         2 Sumeet Patel    A          10-SEP-87
         3 Deepa Jani      A          12-MAR-79
  
Share: 

 
 
 


Rhys Evans
Rhys Evans author of Example to display records of student pass in all subjects and marks are greater than 60 in maths is from London, United Kingdom.
 
View All Articles

Related Articles and Code:


 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!