tsreddy

• Sep 24th, 2014

 

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

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 ;

Jitendra

• Jan 20th, 2015

 

Code
SELECT NAME,pass FROM (


  SELECT DISTINCT NAME,pass FROM STD WHERE MARKS>=40


  UNION


  SELECT DISTINCT NAME,fail FROM STD WHERE MARKS<40) GROUP BY NAME HAVING COUNT(*)=1


  UNION


  SELECT NAME,fail FROM (


  SELECT DISTINCT NAME,pass FROM STD WHERE MARKS>=40


  UNION


  SELECT DISTINCT NAME,fail FROM STD WHERE MARKS<40) GROUP BY NAME HAVING COUNT(*)<>1

Ritesh Kumar

• Mar 24th, 2015

 

Code
WITH t1


       AS (SELECT   name,


                    COUNT ( result )  AS tt_sub_pass


             FROM   student


            WHERE   result >= 40


            GROUP BY name


            ),


    t2


       AS (SELECT   name, COUNT (result)  tt_sub


             FROM   student


             GROUP BY name )


SELECT   t1.name,


         CASE WHEN t1.tt_sub_pass = t2.tt_sub THEN Pass ELSE Fail END


            AS Final_RES


  FROM   t1, t2


  WHERE t1.name=t2.name

Elangovan

• Aug 12th, 2015

 

Code
SELECT name, CASE WHEN min_marks < 40 THEN FAIL ELSE PASS END AS result FROM (


SELECT name, MIN(marks) AS min_marks FROM student GROUP BY name) a