oracleÖв»¼´ÊÇij¸öÖµÔõôд
oracle ÖÐÌåÏÖ²»¼´ÊÇij¸öÖµµÄÓ﷨Ϊ “column_name value”£¬ÀýÈçÒªÅÌÎÊнˮ²»¼´ÊÇ 1000 ÃÀÔªµÄÔ±¹¤£¬¿ÉʹÓà “select emp_id, salary from employees where salary 1000;” ÅÌÎÊ¡£
Oracle Öв»¼´ÊÇij¸öֵд·¨
ÔÚ Oracle ÖУ¬¿ÉÒÔͨ¹ýʹÓà “NOT” ÔËËã·ûÀ´ÌåÏÖ²»¼´ÊÇij¸öÖµ¡£ÏêϸÓï·¨ÈçÏ£º
column_name value
µÇ¼ºó¸´ÖÆ
ÆäÖУº
column_name ÊÇÒª½ÏÁ¿µÄÁÐÃû
value ÊÇÒª½ÏÁ¿µÄÖµ
¾ÙÀý£º
¼ÙÉèÓÐÒ»ÕÅÃûΪ “employees” µÄ±í£¬ÆäÖаüÀ¨ “emp_id” ºÍ “salary” ÁС£ÒªÅÌÎÊнˮ²»¼´ÊÇ 1000 ÃÀÔªµÄÔ±¹¤£¬¿ÉÒÔʹÓÃÒÔÏÂÅÌÎÊ£º
SELECT emp_id, salary FROM employees WHERE salary 1000;
µÇ¼ºó¸´ÖÆ
Õâ¸öÅÌÎʽ«·µ»Ø emp_id ºÍ salary ÁеÄËùÓÐÐУ¬ÆäÖÐ salary Áв»¼´ÊÇ 1000 ÃÀÔª¡£
ÒÔÉϾÍÊÇoracleÖв»¼´ÊÇij¸öÖµÔõôдµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡
ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí£¬°æȨÕùÒéÓë±¾Õ¾Î޹أ¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í尊龙凯时人生就是搏ÂËÓÍ»úÍø¹Ù·½Ì¬¶È£¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ£¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢£¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢£¬ÇëÄúÁ¬Ã¦ÁªÏµ尊龙凯时人生就是搏ʵʱÐÞÕý»òɾ³ý¡£