Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL¾«»ªÊÕ¼¯

order by µÄÊýÖµÐÍÁé»îʹÓÃ
select * from table_a where id=p_id order by decode(º¯Êý,'asc',1,'desc',-1)*jsny;
¿ØÖÆÊÔͼµÄ·ÃÎÊʱ¼ä£º
6.create view ...
as
select ... from where exists(select x from dual where sysdate>=8:00am and sysdate<=5:00pm)
ÃîÓÃdecodeʵÏÖÅÅÐò
select * from tabname
order by decode(mode,'FIFO',1,-1)*to_char(rq,'yyyymmddhh24miss');
select * from tabname
order by decode(mode,'FIFO',rq-sysdate, sysdate-rq)
ÕÒ³öij¸öʱÆÚÄÚ¹¤×÷ÈÕÊý£º
select count(*)
from ( select rownum-1 rnum
from all_objects
where rownum <= to_date('2002-02-28','yyyy-mm-dd') - to_date('2002-
02-01','yyyy-mm-dd')+1 )
where to_char( to_date('2002-02-01','yyyy-mm-dd')+rnum-1, 'D' ) not
in ( '1', '7' )
ÎÒ¾õµÃ²éÑ¯ÖØ¸´¼Ç¼µÄÓï¾ä¾ÍºÜ¾­µä
select rowid,bdsszd from BADWDJ a where a.rowid != (select max(rowid) from BADWDJ b where a.bdsszd =b.bdsszd)
ÓÉËüÒýÉêµÄ¾ÍÓкܶàÓÐÓõÄÓï¾ä£¬Èç×òÌì»Ø´ð±ðÈ˵ÄÅÅÐòµÄÄÑÌâ
select id,bdsszd from BADWDJ a where a.id = (select max(id) from BADWDJ b where a.bdsszd =b.bdsszd) order by id
Ê÷Ðͽṹ±íµÄ²éѯ£º
select ID,PARENT_ID from parent_child
connect by prior id = parent_id
start with id = 1;
1.decodeÕâ¸öº¯ÊýÒ»¶¨ÐèÒª»á£¬ÎÒ¾õµÃsqlµÄÁé»îºÜ¶àµØ·½¶¼ÊÇͨ¹ýÕâ¸öfunctionÀ´ÌåÏֵģ¬Ï൱ÓÚif£¬ºÜºÃÓá£
2.group by£¬Õâ¸ö¶«¶«ÏëÏë¼òµ¥£¬ÆäʵºÃ¶àͳ¼Æ¹¦ÄÜÊÇÀë²»¿ªÕâ¸ö²Ù×÷µÄ¡£oracle8ÖÐÀ©³äÁËgroup by rollupºÍcubeµÄ²Ù×÷¡£ÓÐʱºòÊ¡ÁËÄãºÃ¶à¹¦·òµÄ¡£ÖµµÃ×¢ÒâµÄÊÇ£¬µ±Äã¶ÔÊÂÎï×ö¹ýÓÐЧµÄÈËΪ¹é²¢Ö®ºóÖ´ÐÐgroup by ÍùÍù»á¸üÈÃÈËÐÄ¿õÉñâù¡£
3.ºÜ±íÊúÖõľ­µäд·¨£¬Ò²Òª¼Çס£ºsum(decode( )) group by ...
×¢Ò⣺ÐèÒªÔÚÒ»¸ösubqueryÖÐÈ·¶¨Ò»¸öºáÖÃÅе㡣
4.Ê÷Ðνṹ±íµÄ±éÀúд·¨£ºselect ...from ....
start with ... connect by prior (¸¸×Ó¹ØÏµ±í´ïʽ)
select * from xxx where decode(:var,null,'0',column1) = decode(:var,null,'0',:var);
816ÒÔÉÏµÄ Ò»Ð©·ÖÎöº¯ÊýÈç rank() over() and row_number() over()
µ±È»¹ØÓÚ group by rollup/cubeʹÓõÄÈË¿ÖÅÂÌØ±ðÉÙ
ÈçºÎʵÏÖ×î´óÆ¥ÅäµÄ²Ù×÷?
ÀýÈç:¸ø¶¨×Ö·û´® '1234', ¶ø±íÖпÉÄÜÓмǼÏî'1','12','123','1234','12345',Ҫѡ³ö'


Ïà¹ØÎĵµ£º

SQL Server Compact 3.5 SP2ÒѾ­·¢²¼

Ëæ×ÅVisual Studio 2010µÄ·¢²¼£¬Microsoft SQL Server Compact 3.5Ò²Éý¼¶ÎªMicrosoft
SQL Server Compact SP2¡£
ÏÂÔØµØÖ·ÈçÏ£º
SQL
Server Compact 3.5 SP2 for Windows mobile devices (all platforms &
processors)
 
SQL
Server Compact 3.5 SP2 for Windows desktop (32-bit and 64-bit)
  ......

ÔÚsql serverÖÐÊäÈë'NULL'×Ö·û´®µÄÓÐȤ·¢ÏÖ£¡

Èçͼ1¡¢2£¬id=1µÄÊý¾ÝÊÇNULL£¬ÆäËûµÄΪ·ÇNULLµÄÊý¾Ý¡£
Ò»°ãÇé¿öÏ£¬»áÓÃÁ½ÖÖ·½·¨£¡
·½·¨1.t-sql£ºinsert into E values(1,'NULL')£¬²åÈëºó£¬ÔÚ´ò¿ª±íµÄÇé¿öÏ¿´µ½µÄ
ÊÇ'NULL'£¨ÎÒÏëÊÇΪÁËÇø·ÖNULL£¬²Å¼ÓµÄÒýºÅ£©£¬µ«ÊDzéѯµÄʱºò²»Ó°Ï죬ÏÔʾµÄÊÇNULL£¬
Èçͼ1¡¢2£¬idΪ6µÄÊý¾Ý¡£
Èç¹ûÒª²åÈë´øµ¥ÒýºÅµÄ'NULL'£¬insert i ......

SQL ¶à±íÁªºÏ²éѯ

ºÜÉÙÓÃjoin£¬Õâ´Îѧѧ£¬²¢±¸ÍüÁ½ÆªÎÄÕ£¡
ת×Ô£ºhttp://hcx-2008.javaeye.com/blog/285661
Á¬½Ó²éѯ
ͨ¹ýÁ¬½ÓÔËËã·û¿ÉÒÔʵÏÖ¶à¸ö±í²éѯ¡£Á¬½ÓÊǹØÏµÊý¾Ý¿âÄ£Ð͵ÄÖ÷ÒªÌØµã£¬Ò²ÊÇËüÇø±ðÓÚÆäËüÀàÐÍÊý¾Ý¿â¹ÜÀíϵͳµÄÒ»¸ö±êÖ¾¡£
ÔÚ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÖУ¬±í½¨Á¢Ê±¸÷Êý¾ÝÖ®¼äµÄ¹ØÏµ²»±ØÈ·¶¨£¬³£°ÑÒ»¸öʵÌåµÄËùÓÐÐÅÏ¢´æ·ÅÔÚÒ ......

¾­µäSQLÓï¾ä´óÈ«

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......

¶Ôpl/sql Óï¾äµÄÓÅ»¯£¨Ï¼¯£©

Éϼ¯ÖÐ
//////////////////////////////////////////////////
select n5001 Ãŵê,n5002 ²¿ÃÅ,n5004 С·ÖÀà,n5019 ÉÌÆ·±àÂë,c01d21 ÉÌÆ·Ãû³Æ,
nvl(xse,0)-nvl(dzxs,0) ÏúÊÛ,
mle ëÀû,
nvl(xl,0)-nvl(dzsl,0) ÏúÁ¿
 from
(select n5001,n5002,n5004,n5019,sum(n5011) xse,sum(n5016) mle,sum(n5023) xl
from ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ