ºÃµÄSQLÊÕ¼¯ ²»¶Ï¸üÐÂÖÐ
1.Çó1..10żÊýÖ®ºÍ
select sum(level) from dual
where mod(level,2)=0
connect by level
2.½«update¸Ä»»³ÉÓÃrowidÀ´ÊµÏÖ¡£
£¨1£©ÐµÄд·¨£º
merge into SNAPSHOT120_2010_572 t1
using (select a.rowid rid, b.vip_level, b.manager_name
from xyf_vip_info_new b, snapshot120_2010_572 a
where b.sub_id = a.sub_id) t2
on (t1.rowid=t2.rid)
when matched then
update set t1.vip_level=t2.vip_level, t1.vip_manager=t2.manager_name
when not matched then
insert (t1.vip_level) values (null);
£¨2£©ÐÂÆæµÄд·¨
UPDATE (SELECT a.vip_level, a.vip_manager,b.vip_level AS b_vip_level, b.manager_name
from snapshot120_2010_572 a,xyf_vip_info_new b
WHERE b.sub_id = a.sub_id
)
SET vip_level = b_vip_level,vip_manager=manager_name;
3.Çó¸÷¸ö·ÖÖµºÍ×ܵÄÊýÄ¿
select decode(grouping(a.com_name),1,'Ô±¹¤×ÜÊý',a.com_name),count(b.com_id)
from a,b
where a.com_id=b.com_id
group by rollup(a.com_name);
4. »Ø¹öÊý¾Ýµ½Ìض¨Ê±¼ä
select *
from oj_group
as of timestamp to_date(sysdate,'yyyymmdd hh24:mi:ss' )
Ïà¹ØÎĵµ£º
¶¨Ò壺 ºÎΪ´¥·¢Æ÷£¿ÔÚSQL ServerÀïÃæÒ²¾ÍÊǶÔijһ¸ö±íµÄÒ»¶¨µÄ²Ù×÷£¬´¥·¢Ä³ÖÖÌõ¼þ£¬´Ó¶øÖ´ÐеÄÒ»¶Î³ÌÐò¡£´¥·¢Æ÷ÊÇÒ»¸öÌØÊâµÄ´æ´¢¹ý³Ì¡£
³£¼ûµÄ´¥·¢Æ÷ÓÐÈýÖÖ£º·Ö±ðÓ¦ÓÃÓÚInsert , Update , Delete ʼþ¡£(SQL Server 2000¶¨ÒåÁËеĴ¥·¢Æ÷£¬Õ ......
Èç: ±í:consume_record
×Ö¶Î:consume (moneyÀàÐÍ) date (datetimeÀàÐÍ)
ÇëÎÊÔõôдËÄÌõsqlÓï¾ä·Ö±ð°´ÈÕ,°´ÖÜ,°´ÔÂ,°´¼¾Í³¼ÆÏû·Ñ×ÜÁ¿.
Èç:1ÔÂ 1200Ôª
2ÔÂ 3400Ôª
3ÔÂ 2800Ôª
--°´ÈÕ
select sum(consume),day([date]) from& ......
¡¾»ã×Ü¡¿SQL CODE --- ¾µä·¾«²Ê
Êý¾Ý²Ù×÷Àà SQLHelper.cs
ÎÞÏÞ¼¶·ÖÀà ´æ´¢¹ý³Ì
°ÙÍò¼¶·ÖÒ³´æ´¢
SQL¾µä¶ÌС´úÂëÊÕ¼¯
ѧÉú±í ¿Î³Ì±í ³É¼¨±í ½Ìʦ±í
50¸ö³£ÓÃsqlÓï¾ä
SQL SERVER
ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»
Óαê
¸ù¾Ý²»Í¬µÄÌõ¼þ²éѯ²»Í¬µÄ±í
INNER JOIN Óï·¨
master.dbo.sp ......
select *
from (
select soft.NETMODEL,
soft.softname,
soft.softid ......