Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sql

ÇóÒ»sql²éѯÓï¾ä - MS-SQL Server / »ù´¡Àà

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 Í ......

ÇóÒ»sqlÎÄ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

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ʵÏÖÂð
......

OracleÖÐÕâ¸öÎÊÌâÔõô²éѯ - MS-SQL Server / »ù´¡Àà

½«Éè±íÃû½Ð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 ......

asp sql²éѯÎÊÌâ - Web ¿ª·¢ / ASP

СµÜÓöµ½Ò»¸öÎÊÌ⣺
 ¾ÍÊÇÔÚÊý¾Ý²éѯʱËüÌáʾ ±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£µ«ÊÇwhereºóÃæµÄ¶¼ÊÇÁ½¸ö¶¼ÊÇÊý×Ö°¡
ÎÒµÄÊý¾Ý¿âÊÇÈçÏÂͼ
ÎÒÊǶÔÕâ¸ö±í²éѯÁ½´Î ²¢ÇÒÊÇǶÌ׵ĴúÂë 
HTML code:
<div id=mulu >
<ul>
<%
sql="select * from p_class ......

sql²éѯÓï¾ä - MS-SQL Server / »ù´¡Àà

ÓÐÒ»¸ö±íÃû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Ìî³ä
......

SQLÓï¾ä Çë½Ì - MS-SQL Server / »ù´¡Àà

×Ó±í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]
Ëû¿ÉÄÜϰàÁË
/*
±êÌ⣺°´Ä³×ֶκϲ¢×Ö·û´®Ö®Ò»(¼òµ¥ºÏ²¢)
×÷Õߣº°®Ð¾õÂÞ.ع»ª ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [100] [101] [102] [103] 104 [105] [106] [107] [108] [109]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ