mssql Çó¶à×Ö¶Î×î´óÖµ
//Ïà¹Øsql
SQL code:
create table tb1
(
tId int,
tName nvarchar(20),
class1 int,
class2 int
)
insert into tb1
select 1,'test',10,20
union all
select 1,'test1',20,35
union all
select 1,'test2',30,30
union all
select 2,'test21',30,85
union all
select 2,'test22',50,75
union all
select 3,'test31',60,65
union all
select 3,'test32',70,70
//µ¥¸ö×ֶεĻᣬÏÂÃæÊÇÇ󵥸ö×ֶεÄ
SQL code:
select a.* from tb1 a,(select tId,max(class1) as maxT from tb1 group by tId) b
where a.tId=b.tId and a.class1=b.maxT order by a.tId
//Êý¾ÝÏÔʾÈçÏÂ
SQL code:
tId tName class1 class2
1 test2 30 30
2 test22 50 75
3 test32 70 70
//ÎÒÏëÏÔʾΪ
SQL code:
tId tName maxClass
1 test2 35
2 test22 85
3 test32 70
ÎÒÏëÒªµÄ½á¹û¾ÍÊÇclass1,class2²»Çø·Ö£¬È¡×î´óÖµ¡£
//лл¡£
SELECT TID,TNAME,MAX(CLASS1 )
from (
SELECT TID,TNAME,CLASS1 from TB
UNION
Ïà¹ØÎÊ´ð£º
Ò»¸ö×ÜÕ¾.Èý¸ö×ÓÕ¾¹²ËĸöASP¿ª·¢µÄÕ¾µã;Êý¾Ý¿âÊÇMSSQL2000;ËĸöÕ¾¸÷ÓÐ×Ô¼ºµÄÊý¾Ý¿â(ËĸöÕ¾µãµÄ¿â½á¹¹¶¼ÊÇÒ»ÑùµÄ.),¸÷ÓÐ×Ô¼ºµÄÐÅÏ¢Ìí¼Óºǫ́,ËĸöÕ¾ÊǶÀÁ¢µÄ.ËĸöÕ¾¶¼ÔÚͬһ¸ö·þÎñÆ÷ÖÐ.
ÏÖÔÚÐèÒªÏÖʵ:
Ò».ÈçºÎÈÃ×ÜÕ¾ ......
Ö÷»ú
¿Í»§»úc1,c2,c3,c4,c5............
ÒªÇóÈçºÎ±£Ö¤¿Í»§»úÏòÖ÷»úÌá½»Êý¾Ý¾¡Á¿ÊµÊ±.¿ìËÙ.ÍêÕû
Ö±½ÓÓÃinsert ʱ,Ëø×¡Ö÷»úµÄ±í.ËùÒÔ´Ë·½·¨²»¿ÉÐÐ
Çë¸ßÊÖÖ§ÕÐ..
Èç¹ûÖ»²åÈë¶ø²»¶Á£¬Óõ͸ôÀë¼¶±ð
Äã²åÄãµÄ,Ëû²å ......
ÒѾ¼ÜÉèºÃÁËÓÎÏ·£¬ÄÜÔËÐÐÁË£¡¡¾ÓÎÏ·²»ÊÇÎÒ×öµÄËùÒÔÀïÃæµÄÔ´ÂëʲôµÄ¶¼²»´óÇå³þ¡¿ÓÎϷʹÓõÄÊý¾Ý¿âÊÇMSSQLµÄ¡£
ÏëÓÃÍøÕ¾ÊµÏÖÔÚÍøÒ³ÖÐ×¢²áÕ˺ÅÀ´²åÈëµ½Ö¸¶¨µÄMSsqlÓû§±íÖÐ! ÒÔ±ã´ïµ½ÔÚÍøÕ¾×¢²áÁËÕ˺źóÄÜÔÚÓÎÏ·ÀïÃæ ......
ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ
Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É
Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É
ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..
ÄÇÓÐûÓÐϵͳ´ ......
db2ºÍMSSQLµÄÇø±ð(ÓÈÆäÊÇSQLÓï¾ä·½ÃæµÄÓï·¨£¬»¹ÇëÏêϸµãлл)
»°ÌâÌ«´ó£¬½¨ÒéÏÈÔÚÍøÉÏ×Ô¼ºËÑË÷һϡ£ Äã¿ÉÒÔÌù³ö¾ßÌåµÄijһµãÈôó¼ÒÀ´ÌÖÂÛ¡£
liuzhimsn (liuzhimsn)
'½ØÖÁ2010-03-31 15:46:29 Óû§½áÌ ......