求mysql case 语句

[宇晨007]

如select (a/b) as res；现在要求 a/b 的值小于30，res=1，a/b的值大于30，小于100，res=2，a/b的值大于100，res=3。用case怎么写，请教了

[wwwwb]

SELECT CASE WHEN
a/b<30 THEN 1
WHEN a/b>=30 AND A/B<=100 THEN 2
ELSE 3 END AS RES FROM TT

[liuyann]

SELECT CASE 
	WHEN a/b<30 THEN 1
	WHEN a/b>30 and a/b<100 THEN 2
	ELSE 3 END as res ;

==== 思想重于技巧 ====

reply via CSDN viewer

[lyyshui]

[Quote=引用 2 楼 liuyann 的回复:]
SQL codeSELECTCASEWHENa/b<30THEN1WHENa/b>30anda/b<100THEN2ELSE3ENDasres ;
====思想重于技巧====

reply via CSDN viewer
[/Quote]

[lacasadeco]

SELECT $maxCount=MAX(FEntryID)FROM WincoBosCombinedPmcEntry WHERE(FOrder=6)AND(FMethodID!=2)
GROUP BY FOrder;
当把存储过程中的这句注释掉不执行的时候，网页就可以显示数据出来，是怎么回事呀？