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

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


Ïà¹ØÎÊ´ð£º

MSSQLÈçºÎ²åÈë²»ÏàͬµÄ¼Ç¼ - .NET¼¼Êõ / ASP.NET

ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖØ¸´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿
Çë¿´Çå³þÎÒµÄÌâÄ¿£¬²»Òª´ÓÍøÉϳ­Ò»Ð©´ð°¸¹ýÀ´£¬ÍøÉϺܶàÈËдµÄÏÈselectÔÙinsertµÄ¶¼ÊÇϹ³¶£¬Ñ¹¸ù¾Íû¿¼Âǵ½²¢·¢ÐÔÎÊÌ⣬ÎÒÏÖÔÚ²»Ïë¼ÓÉÏÐòÁл¯ ......

¹ØÓÚMSSQLÔ¼ÊøÃû³ÆµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà

×ֶεÄĬÈÏÖµÔ¼ÊøÉúËùµÄÔ¼ÊøÃû³ÆÏµÍ³³£³£ÔÚºóÃæÌíÉÏÒ»¸öËæ»úµÄ×Ö·û´®£¬
Èç
DF__Admin__locked__014935CB
ÕâÑùÔì³ÉÒÔºóÔÚÐ޸ĸÄÔ¼ÊøµÄʱºòºÜÂé·³£¬ÔõôÉèÖò»ÈÃÊý¾Ý¿â×Ô¶¯Éú³ÉÕâÑùµÄËæ»úÃû³ÆµÄÔ¼ÊøÃû³Æ
¶øÏòÕâÑù ......

MSSQLÔõô»ñÈ¡Êý¾Ý¿âÀúÊ·²éѯ×Ü´ÎÊý

ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É


ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..

ÄÇÓÐûÓÐϵͳ´ ......

mssql ¹ØÓÚwhereÓï¾äµÄλÖÃ

ÀýÈ磺select a.* from (select id,code from b left join c on b.id=c.id)a where id=1
ÕâÀïµÄwhere ÔÚÖ´ÐеÄʱºò£¬ where »áÓÅ»¯ÊÇ·ñ½øÈ뵽СÀ¨ºÅÀïÃæÖ´ÐÐ?????
SQL code:
select id,code from b left join ......

mssqlÈ¥³ýÖØ¸´²¢ÅÅÐòµÄÎÊÌâ

SQL code:
/*
create database temp
use temp
create table employees
(
eID int identity primary key,
eName nvarchar(50) not null,
eSex smallint not null default(1),
eSort smalli ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ