sno sname ssex sbirthday class
---- ----- ---- ----------------------- -----
108 Ôø»ª ÄÐ 1905-05-22 00:00:00.000 95033
105 ¿ïÃ÷ ÄÐ 1905-05-18 00:00:00.000 95031
107 ÍõÀö Å® 1905-05-07 00:00:00.000 95033
101 Àî¾ü ÄÐ 1905-05-09 00:00:00.000 95033
109 Í ......
A±í
×Ö¶Î
A B
Öµ
A001 a1
A001 a2
A001 a3
B001 b1
B002 b2
B±í
×Ö¶Î
A C
A001 c1
B001 c2
B002 c3
ÒªÇóЧ¹û
A001 a1,a2,a3 c1
B001 b1 c2
B002 b2 c3
ÄÜÓÃsqlʵÏÖÂð
......
½«Éè±íÃû½Ðtest£¬°´ID½µÐòÅÅÁУ¬È»ºó´Ó±íÖÐÕÒ³öµÚ3£¬µÚ4Ìõ¼Ç¼£¨±íÖеļǼ·Ç³£¶à£©¡£
select * from tb where rownum between 3 and 4
ÒýÓÃ
½«Éè±íÃû½Ðtest£¬°´ID½µÐòÅÅÁУ¬È»ºó´Ó±íÖÐÕÒ³öµÚ3£¬µÚ4Ìõ¼Ç¼£¨±íÖеļǼ·Ç³£¶à£©¡£
--°´ID½µÐòÅÅÁÐ
SQL code:
select * from tb where rownum between 3 and 4 order b ......
СµÜÓöµ½Ò»¸öÎÊÌ⣺
¾ÍÊÇÔÚÊý¾Ý²éѯʱËüÌáʾ ±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£µ«ÊÇwhereºóÃæµÄ¶¼ÊÇÁ½¸ö¶¼ÊÇÊý×Ö°¡
ÎÒµÄÊý¾Ý¿âÊÇÈçÏÂͼ
ÎÒÊǶÔÕâ¸ö±í²éѯÁ½´Î ²¢ÇÒÊÇǶÌ׵ĴúÂë
HTML code:
<div id=mulu >
<ul>
<%
sql="select * from p_class ......
ÓÐÒ»¸ö±íÃûdemoµÄ±í£¨Óиösex×Ö¶ÎÊÇintÀàÐÍ£©£¬Ïë²éѯÈç¹ûÊÇ0ÔòÊä³ö¡°ÄС±,1Ôò¡°Å®¡±,²¢´æÈë±ítemp(×Ô¼ºÁÙʱ´´½¨µÄÒ»Õűí)ÖÐsqlÓï¾ä£¬×¢Òâ²»ÊÇ´æ´¢¹ý³Ì£¬ÊÇsqlÓï¾ä
SQL code:
insert temp
select case sex when 0 then 'ÄÐ' when 1 then 'Å®' end from demo
δÌîÐÔ±ðµÄÓÃnullÌî³ä
......
×Ó±ía
ID Ô·Ý
1 2010-01
1 2010-02
1 2010-01
2 2010-03
²éѯ½á¹û
id Ô·Ý
1 2010-01/2010-02
2 2010-03
ÔõôʵÏÖ
ÐÐÁкϲ¢£¬½»¸øÐ¡F
SQL code:
[Quote=ÒýÓà 1 Â¥ guguda2008 µÄ»Ø¸´:]
ÐÐÁкϲ¢£¬½»¸øÐ¡F
[/Quote]
Ëû¿ÉÄÜϰàÁË
/*
±êÌ⣺°´Ä³×ֶκϲ¢×Ö·û´®Ö®Ò»(¼òµ¥ºÏ²¢)
×÷Õߣº°®Ð¾õÂÞ.ع»ª ......