postgresqlÀïÓÐûÓÐÏñoracleÖеÄÄÇÀà·ÖÎöº¯Êý?
postgresqlÀïÓÐûÓÐÏñoracleÖеÄÄÇÀà·ÖÎöº¯Êý? Èç¹ûûÓеϰ,ÓÐûÓÐʲôÆäËû°ì·¨¿ÉÒÔʵÏÖÀàËÆ¹¦ÄÜÄØ?
¾ßÌåÊÇʲô·ÖÎöº¯Êý?ÒýÓà ÓÐÈçϺ¯Êý¡£ Function row_number() rank() dense_rank() percent_rank() cume_dist() ntile(num_buckets, integer) lag(value, any [, offset, integer [, default, any ]]) lead(value, any [, offset, int¡¡ лл ÎÒ¸ÕÊÔÁËÏÂrow_number()ÊÇÓÐµÄ http://www.postgresql.org/docs/8.4/interactive/functions-window.html ¸Õ¸ÕÈ¥ËÑÁËһϠËѵ½ÁËÕâ¸öÁ´½Ó ²»¹ýÀïÃæÃ»ÓÐÿ¸öº¯Êý¸ü¼ÓÏêϸµÄ½²½â ÇëÎÊÒ»ÏÂÓÖûÓÐʲôºÃµãµÄµØ·½»òÕßÎĵµ¿ÉÒÔѧϰPOSTGRESQLÒýÓà ¾ßÌåÊÇʲô·ÖÎöº¯Êý? ºÇºÇ ÏÖÔÚµ¹»¹Ã»¾ßÌ嵽ij¸öº¯Êý Ö»ÊÇ×î½ü¿ÉÄÜ»áÔÚGREENPLUMÉÏ×ö¿ª·¢ ÒÔǰ´ÓÀ´Ã»Óùý Ö»ÓùýORACLE ËùÒÔÏÖÔÚÏë±È½Ïһ϶þÕߵIJ»Í¬Ö®´¦Ñ§Ï°Ñ§Ï°POSTGRESQLµÄÓï·¨ PS£ºÄãµÄС»¨¶àµÃ¹ý·Ö¡¡ ÇëÎÊÒ»ÏÂÓÖûÓÐʲôºÃµãµÄµØ·½»òÕßÎĵµ¿ÉÒÔѧϰPOSTGRESQL Ö±½Óµ½PostgreSQL ¹ÙÍøÉÏÏÂÔØËüµÄÎĵµ¾ÍÐÐÁË£¬²»¹ý²»Èç£Ï£Ò£Á£Ì£Ã£ÅµÄÏêϸ¡£ Manuals Release Online Version Downloadable Version 8.4 •With user comments •Without user comments •Comprehensive Manual: A4 PDF (17 MB) •Comprehensive Manual: US PDF (17 MB) •Windows help file (3.3 MB) 8.3 •With user comments •Without user comments &
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ £¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²» ......