The student who got >=40 student is passes and

S_NAME MARKS
ramu 60
ramu 40
ramu 50
karan 30
karan 96
karan 46
out put:
ramu "PASS"
karan "FAIL"

Questions by Rakesh057   answers by Rakesh057

Showing Answers 1 - 5 of 5 Answers

tsreddy

  • Sep 24th, 2014
 

s_name marks is >=40 "pass",else "fail"

  Was this answer useful?  Yes

vb

  • Sep 24th, 2014
 

SELECT SNAME,
CASE WHEN M1>40 AND M2>40 AND M3>40 THEN "PASS"
ELSE
"FAIL"
END AS STATUS
FROM STUDENT ;

  Was this answer useful?  Yes

Jitendra

  • Jan 20th, 2015
 

Code
  1.  


  Was this answer useful?  Yes

Ritesh Kumar

  • Mar 24th, 2015
 

Code
  1.  

  Was this answer useful?  Yes

Elangovan

  • Aug 12th, 2015
 

Code
  1.  

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions