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;

SOnali

• Jun 29th, 2016

 

Select Name,
when Min(Mark)>40
Then Pass
Else Fail
End
From TableName
Group By Name

nancy

• Jul 19th, 2016

 

Code
SELECT Name,


when Min(Mark)>40


Then Pass


Else Fail


End


FROM TableName


GROUP BY Name