VMWare Inc Interview Question
Software Engineer / Developerscreate table score(
name varchar(25),
marks int
);
insert into score values ('A',500);
insert into score values ('B',700);
insert into score values ('C',400);
insert into score values ('D',900);
insert into score values ('E',200);
select name,
CASE
WHEN marks > 700 THEN 'A'
ELSE 'C'
END
as grade
from score;
NAME GRADE
A C
B C
C C
D A
E C
create table score(
name varchar(25),
marks int
);
insert into score values ('A',500);
insert into score values ('B',700);
insert into score values ('C',400);
insert into score values ('D',900);
insert into score values ('E',200);
select name,
CASE
WHEN marks >= 700 THEN 'A'
WHEN marks >= 500 AND marks <700 THEN 'A'
ELSE 'C'
END
as grade
from score;
NAME GRADE
A B
B A
C C
D A
E C
Select name,
- Anonymous December 11, 2010'Grade' = case when marks > 700 then 'A'
when marks > 500 and marks <= 700 then 'B'
else 'C'
end case
from table t;
In Oralce, you could use 'decode'.