mssql ¶à±í²éѯµÄÎÊÌâ
ÇëÎÊ£ºÔÚ¶à±í²éѯÖУ¬²éѯ²»Í¬±íÖеĶà¸ö×ֶΣ¬ÆäÖÐÓÐЩ×ֶΰüÀ¨º¯Êý£¬¶àл¸÷λ´óÏÀÖ¸µãÃÔ½ò°¡£¡£¡£¡
±í1
¹¤ºÅ ÐÕÃû
1 Ëν
2 ¬¿¡Òå
±í2
¹¤ºÅ µÃ·Ö ÆÚÊý
1 50 1
1 60 2
1 64 3
²éѯ½á¹û
ÐÕÃû µÃ·Ö£¨ÈýÆÚµÄavg£©
Ëν 58
SQL code:
select ÐÕÃû,µÃ·Ö=avg(µÃ·Ö) from ±í1 A,±í2 B where A.¹¤ºÅ=B.¹¤ºÅ
group by ÐÕÃû
SQL code:
select ÐÕÃû,avg(µÃ·Ö) as µÃ·Ö
from ±í1 inner join ±í2 on ±í1.¹¤ºÅ=±í2.¹¤ºÅ
group by ÐÕÃû
SQL code:
select a.¹¤ºÅ,a.ÐÕÃû,µÃ·Ö=avg(b.µÃ·Ö)
from ±íÒ» a inner join ±í¶þ b on a.¹¤ºÅ=b.¹¤ºÅ
group by a.¹¤ºÅ
SQL code:
1> select * from ±í1;
2> go
¹¤ºÅ |ÐÕÃû
-----------|----------
1|Ëν
2|¬¿¡Òå
(2 rows
Ïà¹ØÎÊ´ð£º
ÎÒÉè¼ÆµÄ
Óû§ÐÅÏ¢±í ³±íÊý¾Ý±í ÀúÊ·³±íÊý¾Ý±í
ÎÒµÄÏë·¨ÊÇ Ã¿Ô³õ ϵͳ×Ô¶¯ÔÚ ³±íÊý¾Ý±íÖÐÉú²ú ÓëÓû§¹ØÁªµÄÊý¾Ý ÓÃÓÚ³±íÔ±µÄ¼È룬µ±³±íԱȫ²¿Â¼Èëºó °ÑÊý¾ÝÈ«²¿¸´ÖƵ½ÀúÊ·±íÖРͨʱ ......
ÔÊý¾Ý----------------------------
a b
49 ƤÊéϵÁÐ
50 ¾¼Ã ......
ÓÉÓÚ×î½üҪдһ¸ö·ÖÒ³µÄ³ÌÐò£¬ÔÚÍøÉÏÕÒÁ˸ö´æ´¢¹ý³Ì£»
create procedure add_pp_SqlPager
@sqlstr nvarchar(4000), --²éѯ×Ö· ......
°ì¹«ÊÒÀïÓÐ6̨µçÄÔ£¬ÆäÖÐһ̨װÓÐMSSQL 2005 ×÷Ϊ·þÎñÆ÷£¬ÁíÍâÎą̊µçÄÔ¸÷ÓÐÒ»¸öÓû§Ãû£¬¶¼ÉèÖóɿÉÒÔ·ÃÎʵÄÁË¡£µ«Ö»ÓÐÁ½Ì¨¿ÉÒÔÁ¬ÉÏÊý¾Ý¿â£¬ÆäËûµÄ±¨´í£º[DBNETLIB][ConnectionOpen (Connect()).]SQL Server ²»´æÔÚ»ò ......
Èç¹ûÓÃ×Ô¶¯Ôö³¤ÁÐ.»á³öÏÖµ±²åÈëÒì³£Ê±ÌøºÅ
ËùÒÔ²»µÃ²»Óô洢¹ý³Ì
±íÃû qfjh_bocai_dlt
Ö÷¼ü qishu
ÈÃqishu´Ó1¿ªÊ¼µÝÔö,Ò»¶¨Òª±£³ÖÁ¬ÐøÐÔ ²»´æÔÚÌøºÅÏÖÏó
..²»ÊǰÉ.ûÈË»áдÂð¡£
ÕâÕâÑù×ö£¬ ......