Çë½ÌÈçºÎ½«SQL²éѯ³öµÄÊý¾Ý¸Ä±äÑÕÉ«¸ßÁÁÏÔʾ
Çë½ÌÎÒÓÃsql²éѯ³öÒ»ÕÅ±í£¬ÎÒÏ뽫²¿·ÖÊý¾ÝÐиıäÑÕÉ«£¬Í»³öÏÔʾ£¬²»ÖªÓÐʲô·½·¨Ã»
ÀýNAME SCORE
A 90
B 87
C 56
D 45
½«·ÖÊýÔÚ60ÒÔϵĸßÁÁÏÔʾ
Õâ¸ö¿ÉÒÔÓÃcase when score <60 then 'xxx' end
xxxÀïÃæ¼ÓÈëÑÕÉ«µÈÑùʽ´úÂ룬ÔÚǰ̨ͻ³ö±íÏÖ
ËÆºõ²»¿ÉÒÔ£¬ÎҵıíÈçÏÂ
staff_id dept_code
11102 114
11103 114
11114 116
select staff_id ,case when
dept_code=114 then '#990033' end
from prl_epay_staff
½á¹û
staff_id case when dept_code=114 then '#990033' end
11102 #990033
11103 #990033
11114 null
ORACLEÓÃÓÚ´æ´¢Êý¾Ý,²¢²»Õ¹Ê¾Êý¾Ý,չʾÊý¾ÝµÄ»°,ÐèҪǰ¶ËÓ¦ÓóÌÐòʵÏÖ
Ëü°Ñ '#990033' µ±³É×Ö´®¸ø½âÊÍÁË
ÎÒ¾õµÃ wildwaveµÄÒâ˼ÊÇ °Ñ²éѯ³öÀ´µÄ×Ö¶Î Æ´ÉÏÑùʽ´® ÄÜÉÏǰ̨html½âÎöµÄÑùʽÂë
ÄѵÀORACLEÀïûÓÐʲô·½·¨¿ÉÒÔʵÏÖô
ORACLE¾ÍûÓÐչʾ¹¤¾ß°¡,SQL*PLUSÒ²ÊÇǰ¶Ë¹¤¾ß°¡,µ«ÊÇSQL*PLUSûÓжÔÓ¦µÄ½Ó¿Ú±à³ÌʵÏÖ,
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
¹ØÓÚSQL Server Mobile Edition
ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf
ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......