Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Example to view records of student having marks greater than 70 and course name is FOP

Posted By: Amy Brown     Category: Oracle     Views: 3538

This article provides an example to view records of student having marks greater than 70 and course name is FOP.

Code for Example to view records of student having marks greater than 70 and course name is FOP 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 c.coursename='FOP'and sc.marks > 70;

    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
         4 Mona Amin       B          08-APR-81
  
Share: 

 
 
 


Amy Brown
Amy Brown author of Example to view records of student having marks greater than 70 and course name is FOP 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!