SQLº¯Êý
SQLº¯Êý
ÔÚSQLÖУ¬º¯Êý¶ÔÊý¾Ý»òÊý¾Ý×éÖ´ÐвÙ×÷£¬È»ºó·µ»ØÐèÒªµÄÖµ¡£º¯Êý±í´ïʽ¿ÉÒÔ³öÏÖÔÚSELECTÁбíÖУ¬»òÕß
ÔÚÈκÎÔÊÐí³öÏÖµÄλÖÃÉÏ¡£SQL°üº¬ÁËÆßÖÖº¯Êý:
(1)¾ÛºÏº¯Êý:·µ»Ø»ã×ÜÖµ¡£
(2)תÐͺ¯Êý:½«Ò»ÖÖÊý¾ÝÀàÐÍת»»ÎªÁíÍâÒ»ÖÖ¡£
(3)ÈÕÆÚº¯Êý:´¦ÀíÈÕÆÚºÍʱ¼ä¡£
(4)Êýѧº¯Êý:Ö´ÐÐËãÊõÔËËã¡£
(5)×Ö·û´®º¯Êý:¶Ô×Ö·û´®¡¢¶þ½øÖÆÊý¾Ý»ò±í´ïʽִÐвÙ×÷¡£
(6)ϵͳº¯Êý:´ÓÊý¾Ý¿â·µ»ØÔÚSQLSERVERÖеÄÖµ¡¢¶ÔÏó»òÉèÖõÄÌØÊâÐÅÏ¢¡£
(7)Îı¾ºÍͼÏñº¯Êý:¶ÔÎı¾ºÍͼÏñÊý¾ÝÖ´ÐвÙ×÷¡£
1¡¢¾ÛºÏº¯Êý:Ëü¶ÔÆäÓ¦ÓõÄÿ¸öÐм¯·µ»ØÒ»¸öÖµ¡£
º¯Êý ·µ»ØÖµ
AVG£¨±í´ïʽ£© ·µ»Ø±í´ïʽÖÐËùÓÐµÄÆ½¾ùÖµ¡£½öÓÃÓÚÊý×ÖÁв¢×Ô¶¯ºöÂÔNULLÖµ¡£
COUNT£¨±í´ïʽ£© ·µ»Ø±í´ïʽÖзÇNULLÖµµÄÊýÁ¿¡£¿ÉÓÃÓÚÊý×ÖºÍ×Ö·ûÁС£
COUNT£¨*£© ·µ»Ø±íÖеÄÐÐÊý£¨°üÀ¨ÓÐNULLÖµµÄÁУ©¡£
MAX£¨±í´ïʽ£© ·µ»Ø±í´ïʽÖеÄ×î´óÖµ£¬ºöÂÔNULLÖµ¡£¿ÉÓÃÓÚÊý×Ö¡¢×Ö·ûºÍÈÕÆÚʱ¼äÁС£
MIN£¨±í´ïʽ£© ·µ»Ø±í´ïʽÖеÄ×îСֵ£¬ºöÂÔNULLÖµ¡£¿ÉÓÃÓÚÊý×Ö¡¢×Ö·ûºÍÈÕÆÚʱ¼ä
ÁС£
SUM£¨±í´ïʽ£© ·µ»Ø±í´ïʽÖÐËùÓеÄ×ܺͣ¬ºöÂÔNULLÖµ¡£½öÓÃÓÚÊý×ÖÁС£
2¡¢×ª»»º¯Êý:ÓÐCONVERTºÍCASTÁ½ÖÖ¡£
CONVERTʵÀý: Select convert(varchar(10) ,stuno) as stuno,stuname from student
CASTʵÀý: Select cast(stuno as varchar(10)) as stuno,stuname from student
×¢Òâ:
1)Èç¹ûûÓÐÖ¸¶¨±í´ïʽת»»ºóµÄËùµÃµ½µÄÊý¾ÝÀàÐ͵ij¤¶È£¬ÔòSQLSERVER×Ô¶¯ÌṩµÄ³¤¶ÈΪ30¡£
2)ת»»ÎªÎ»£¨bit£©ÀàÐÍʱ£¬»á½«ÈκηÇÁãֵת»»Îª1¡£
3)ת»»Îªmoney»òsmallmoneyÀàÐÍʱ£¬¼Ù¶¨»õ±Òµ¥Î»ÎªÕûÊý¡£
4)½öµ±char»òvarcharÊý¾ÝÀàÐͱíʾÊý×Öʱ£¬¿ÉÒÔת»»ÎªÕûÊýÊý¾ÝÀàÐÍ¡£
5)½«char»òvarcharÊý¾ÝÀàÐÍת»»ÎªmoneyÀàÐÍʱ£¬¿É°üº¬Ð¡ÊýµãºÍÃÀÔª·ûºÅ£¨$£©¡£
6)½«char»òvarcharÊý¾ÝÀàÐÍת»»Îª¸¡µã»òʵÊýÀàÐÍʱ£¬¿É°üº¬Ö¸Êý·ûºÅ¡£
7)Èç¹û¶ÔеÄÊý¾ÝÀàÐ͵ĶøÑÔÖµ¹ý³¤£¬ÔòÖµ½«±»½Ø¶Ï¡£
8)¿ÉÒÔÏÔʾµÄ·½·¨½«TextÁÐת»»Îªchar»òvarcharÁУ¬ÒÔ¼°½«imageÁÐת»»Îªbinary»òvarbinaryÁС£µ«ÊÇ£¬²»Äܳ¬¹ý255¸ö×Ö·û¡£
3¡¢ÈÕÆÚº¯Êý
ÓÉÓÚ²»ÄÜÖ±½ÓÖ´ÐÐËãÊõº¯Êý£¬ËùÒÔÈÕÆÚº¯Êý¾ÍÊ®·ÖÓÐÓá£
Ëü¿ÉÒÔ°ïÖúÄúÎöÈ¡³öÈÕÆÚÖµÖеÄÌì¡¢ÔºÍÄ꣬ÕâÑù¾Í¿ÉÒÔ·Ö±ð´¦ÀíËüÃÇ¡£
ÔÚSQLÖУ¬Èͮ򵀱íʾ·½·¨¼°ÓÐЧ·¶Î§£¬ÈçÏÂ:
ÈÕÆÚ²¿·Ö Ëõд Öµ ÈÕÆÚ²¿·Ö Ëõд Öµ
Ïà¹ØÎĵµ£º
±¾ÎĽéÉÜÁËSQL Server 2008ÀïһЩеÄÌØµãÒÔ¼°·¢ÏÖµÄһЩ¾«ÃîÖ®´¦……
¡¡¡¡°²×°
¡¡¡¡SQL
Server
2008µÄÉèÖúͰ²×°Ò²ÓÐËù¸Ä½ø¡£ÅäÖÃÊý¾ÝºÍÒýÇæÎ»ÒѾ·Ö¿ªÁË£¬ËùÒÔËüʹ´´½¨»ù±¾µÄδÅäÖÃϵͳµÄ´ÅÅÌͼÏñ±äµÃ¿ÉÄÜÁË£¬Ëüʹ·Ö²¼µ½¶à¸ö·þÎñÆ÷±äµÃ¸üÈÝÒ×ÁË¡£
´Ó΢ÈíµÄÕ¾µãÒ²¿ÉÒÔÕÒµ½°²×°¿ÉÓõÄ×îиüС£ÁíÒ»¸öÌØµ ......
Microsoft SQL Server
2008ºÍMicrosoftÊý¾Ýƽ̨Ϊ¿ª·¢ÈËÔ±ÌṩÁËÒ»¸ö×ۺϵıà³Ì¼Ü¹¹£¬ÓÃÓÚ´´½¨Õë¶ÔÒÆ¶¯É豸¡¢×ÀÃæµçÄÔ¡¢Web·þÎñÆ÷£¬ºÍÆóÒµ·þÎñÆ÷µÄ»ùÓÚÊý¾ÝµÄ½â
¾ö·½°¸¡£Õâ¸öÊý¾Ý±à³Ì»·¾³½«Êý¾Ý·ÃÎʺ͹ÜÀí¼¯³Éµ½Ò»¸öÓ¦ÓóÌÐòµÄÒµÎñÂß¼ÖУ¬´Ó¶øÌá¸ßÁË¿ª·¢ÈËÔ±µÄÉú²úÁ¦¡£ËüÌṩÁËÒ»¸öÓÃÓÚ¶ÔÒì¹¹Êý¾ÝÔ´µÄÊý¾Ý·ÃÎʺ͹ÜÀí
µÄ ......
×ªÔØ×Ô£ºhttp://www.cnblogs.com/leonbao/archive/2008/03/07/1094821.html
¹ØÓÚSQL ServerÊý¾Ý¿âÉè¼ÆµÄ¸ÐÎò£¬ÇëÖ¸½Ì
ÓÐÎÊÌâµÄʱºò£¬ÎÒ¾³£»ØÀ´²©¿Í԰ѰÕҴ𰸣¬¾Ã¶ø¾ÃÖ®£¬×ܽáÁËһЩ¶«Î÷¡£
Íý×ԷƱ¡£¬Çë´ó¼Ò¶àÖ¸³ö´íÎ󣬲¢¸ø³öÒâ¼û
Êý¾Ý¿âÉè¼ÆÈý·¶Ê½»ù±¾ÔÔò
µÚÒ»·¶Ê½£ºÊý¾Ý¿â±íÖеÄ×ֶζ¼Êǵ¥Ò»ÊôÐԵ쬲»¿ÉÔÙ·Ö¡£Õâ ......
¡¾ÒýÓãºÃÍáï¼¼ÊõÎÄÕÂÕªÒª
¡¿
¾²âÊÔ£¬·½·¨¶þ¿É³É¹¦É¾³ýÊý¾Ý£¬·½·¨Ò»¡¢Èý ɾ³ýÊý¾Ýʧ°Ü¡£Çë·¹ýµÄÅóÓÑ£¬Ö¸µãÃÔ½ò¡£¡£¡£
ÎÊÌ⣺һ¸ö±íÓÐ×ÔÔöµÄID
ÁУ¬±íÖÐÓÐһЩ¼Ç¼ÄÚÈÝÖØ¸´£¬Ò²¾ÍÊÇ˵ÕâЩ¼Ç¼³ýÁËID
²»Í¬Ö®Í⣬ÆäËûµÄÐÅÏ¢¶¼Ïàͬ¡£ÐèÒª°ÑÖØ¸´µÄ¼Ç¼±£ÁôÒ»Ìõ£¬Ê£ÏµÄɾ³ý
·½·¨Ò»£º»¹ÊÇ2000
ÄêµÄʱºòһλOracl ......