Case usage in SQL statements

Create Table Hu (

Name varchar2 (22 ),
Sal number

);
Select * from Hu;
Insert into hu values ('java', 2300 );
Insert into hu values ('shenzhen, 6000 );
Insert into hu values ('huhu', 6700 );
Insert into hu values ('huhu', 670 );
Insert into hu values ('jia, 1800 );

--------------------------------------------------------

Select H .*,
Case
When Sal <2000 then 'no'
Else 'no restart'

End as Stu from hu h;

------------------------------------------------------

Syntax:

Case where then end

 

Used together. Else is optional.