SQL ѧϰ±Ê¼ÇÖ®SelectÍêÕûÓï·¨¼°Ö´Ðйý³ÌÏê½â
SELECTÓï¾äµÄÍêÕûÓ﷨Ϊ£º
SELECT[ALL|DISTINCT|DISTINCTROW|TOP]
{*|talbe.*|[table.]field1[AS alias1][,[table.]field2[AS alias2][,…]]}
from tableexpression[,…][IN externaldatabase]
[WHERE…]
[GROUP BY…]
[HAVING…]
[ORDER BY…]
[WITH OWNERACCESS OPTION]
×¢Òâ Where£¬GroupBy£¬Having£¬OrderBy ˳Ðò¡£
Ö´Ðв½Öè
1£©ÏÈ´Ófrom×Ö¾äÒ»¸ö±í»ò¶à¸ö±í´´½¨¹¤×÷±í
2£©½«whereÌõ¼þÓ¦ÓÃÓÚ1£©µÄ¹¤×÷±í£¬±£ÁôÂú×ãÌõ¼þµÄÐÐ
3£©GroupBy ½«2£©µÄ½á¹û·Ö³É¶à¸ö×é
4£©Having ½«Ìõ¼þÓ¦ÓÃÓÚ3£©×éºÏµÄÌõ¼þ¹ýÂË£¬Ö»±£Áô·ûºÏÒªÇóµÄ×é¡£
5£©Order By¶Ô½á¹û½øÐÐÅÅÐò¡£
ʹÓÃDISTINCTÈ¥³ýÖØ¸´µÄÐÅÏ¢
Ö´ÐУº
select * from student
·µ»Ø½á¹û
-stuName -stuno
Tom Sawyer 1
Andy Ke 2
Angelia Jolie 3
Celine Dion 4
alex 5
alex 6
Ö´ÐУº
select distinct stu_name from student
½á¹û£º
alex
Andy Ke
Angelia Jolie
Celine Dion
Tom Sawyer
¼´È¥µôÁËÖØ¸´Öµ£¬ÓÖ¶Ô²éѯ½á¹û½øÐÐÁËÅÅÐò¡£Êµ¼ÊÉÏDBMSµÄ²Ù×÷¹ý³ÌÊÇÏȶԲéѯ½á¹ûÅÅÐòÔÚ´Ó½á¹ûÖÐÈ¥³ýÖØ¸´µÄ
Ïà¹ØÎĵµ£º
1¡¢PL
/SQL
Developer¼ÇסµÇ½ÃÜÂë
ÔÚʹÓÃPL
/SQL
Developerʱ£¬ÎªÁ˹¤×÷·½±ãÏ£ÍûPL
/SQL
Developer¼ÇסµÇ¼OracleµÄÓû§ÃûºÍÃÜÂ룻
ÉèÖ÷½·¨£ºPL
/SQL
Developer 7.1.4 ->tools->Preferences->Oracle->Logon History
£¬ “Store history”ÊÇĬÈϹ´Ñ¡µÄ£¬¹´ÉÏ ......
¹ØÓÚPL/SQLÖжԴ洢¹ý³Ìadd debug information
http://space.itpub.net/13129975/viewspace-626245
Èç¹ûʹÓÃPL/SQL DeveloperÖÐÑ¡ÔñÒ»¸ö´æ´¢¹ý³Ìdebugµ«ÓÖdebug²»½øÈ¥£¡
½â¾öÕâ¸öÎÊÌâÊǺܼòµ¥µÄ£¬Ö»ÐèÒªÔÚPL/SQL DeveloperÖÐÑ¡ÔñÒªdebugµÄ´æ´¢¹ý³Ì£¬È»ºóµãÓÒ¼ü£¬ÔÚµ¯³öµÄ²Ëµ¥ÖÐÑ¡Ôñ"Add debug information"ºóÔÙÖ ......
1 µ±Ê¹ÓÃgroup byʱ£¬Î´ÔÚgroup by ²¿·ÖÓõ½µÄ±íÁÐÔÚs e l e c t²¿·Ö³öÏÖʱ±ØÐëʹÓ÷Ö×麯Êý¡£
select last_name, state_cd, sum(sales) from customer group by last_name;
ERROR at line 1:
ORA-00979: not a GROUP BY expression.
state_cdÓ¦¸ÃʹÓ÷Ö×麯Êý£¬m a x ( )¡¢m i n ( )¡¢s u m ( )¡¢c o u n t ( )»òa v g ......
¡¡ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
¡¡¡¡select * from v$version;
¡¡¡¡²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
¡¡¡¡select sum(bytes)/(1024*1024) as free_space,tablespace_name
¡¡¡¡from dba_free_space
¡¡¡¡group by tablespace_name;
¡¡¡¡SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
¡¡¡¡(B.BYTE ......