Studetnt Result should get Pass (or) Fail

Hi guys try this query
If any student fails in one subject also his result should be Faile r else Pass
condtion is(marks>=40 "PASS" marks<=40 "FAIL")
s_name marks
ramu 60
ramu 40
ramu 50
karan 30
karan 96
karan 46
o/p: karan Fail
ramu Pass

Rakesh057
Profile Answers by Rakesh057 Questions by Rakesh057
Sep 9th, 2014
3
13898

Questions by Rakesh057 answers by Rakesh057

SQL

Answer

Showing Answers 1 - 3 of 3 Answers

Dasish

Dec 13th, 2014

If all the marks are defined in a row with different column then try the below
Select sname, decode( least(m1,m2,...........) >= 40, pass,fail) from student;
If the mark is defined in multiple row in one column the try follow
Select roll, sname, decode(min(mark) >= 40 , pass, fail) from student group by roll, sname;