Çó¹ØÓÚɾ³ýMYSQLÖеÄÖØ¸´¼Ç¼µÄSQLÓï¾ä
Êý¾Ý±í£¨sns)£º
sn lastlogin
----------------------
456 2010-01-01
123 2010-02-01
123 2010-02-02
123 2010-02-03
123 2010-02-04
123 2010-02-05
123 2010-02-06
. .
. .
. .
ÒªÇóÿ¸ö sn ×î¶à±£Áô5Ìõ¼Ç¼£¬½«´óÓÚ5Ìõ¼Ç¼µÄsnµÄ×îÔçµÇ¼µÄ¼Ç¼ɾ³ý
SQLÓï¾ä¸ÃÔõôд£¿
лл£¡
¿ÉÒÔÁË£¬Ð»Ð»£¡
Èç¹ûÒª±£ÁôÊ×Ìõ¼Ç¼£¨¼´Ê״εǼµÄ¼Ç¼£©£¬ÆäËûÒªÇ󲻱䣬ÓÖ¸ÃÔõÃ´Ð´ÄØ£¿
лл£¡
ÎÒ²©¿ÍÉÏÓÐÀý×Ó¡£LZ¿ÉÒÔ¿´¿´¡£
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......