Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çë½ÌÈçºÎ½«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ûÓжÔÓ¦µÄ½Ó¿Ú±à³ÌʵÏÖ,


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

¹ØÓÚSQL Server Mobile Edition - .NET¼¼Êõ / ASP.NET

¹ØÓÚSQL Server Mobile Edition
ÓÃMicrosoft SQL Server2005 Management Studio Express9.00.3042.00´´½¨SQLCEÊý¾Ý¿âsqlmobile.sdf
ÔÚmobileϵͳÖÕ¶ËÉÏÓÃSQL Server Mobile Edition3.0Äܲ鿴sqlmobile.sdfÀï±íÊý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ