Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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È¥³ýÖØ¸´ÏîÓï¾ä


»ù´¡±íA¡¢BÈçͼ£¬ÓÉÓÚÒ»ÌõÐÂÎÅÖпÉÄÜÓжàÕÅͼƬ£¬ËùÒÔBÖлá³öÏÖ¶à¸öͼƬ±àºÅ¶ÔÒ»¸öÐÂÎűàºÅµÄÇé¿ö¡£
Çó´´½¨C±í£¨ÊÓͼ£©µÄsqlÓï¾ä¡£
SQL code:
select
b.pictureid as ͼƬ±àºÅ,a.newstitle as ÐÂÎűêÌâ,a.n ......

db2ºÍMSSQLµÄÇø±ð

db2ºÍMSSQLµÄÇø±ð(ÓÈÆäÊÇSQLÓï¾ä·½ÃæµÄÓï·¨£¬»¹ÇëÏêϸµãлл)
»°ÌâÌ«´ó£¬½¨ÒéÏÈÔÚÍøÉÏ×Ô¼ºËÑË÷һϡ£ Äã¿ÉÒÔÌù³ö¾ßÌåµÄijһµãÈôó¼ÒÀ´ÌÖÂÛ¡£

liuzhimsn (liuzhimsn)
  '½ØÖÁ2010-03-31 15:46:29 Óû§½áÌ ......

MSSQL´¥·¢Æ÷Ϊʲô×Ô¶¯É¾³ýÁË??????????

ÏÂÃæÊÇÎÒ´´½¨µÄÒ»¸ö´¥·¢Æ÷,µ±¹â·üµç³ØÊýÖµ³¬¹ýÉ趨µÄ·¶Î§¾Í»á²åÈë¹ÊÕϱí,
µ«ÊÇÔÚ¸Õ¸Õ½¨Á¢µÄ´¥·¢Æ÷ʱ,¿ÉÒÔ½«¹ÊÕÏÊý¾Ý²åÈëµ½¹ÊÕϱí,Ö®ºóÕâ¸ö´¥·¢Æ÷¾Í×Ô¶¯ÏûʧÁË.Ò²¾ÍÊÇ´´½¨¹ýºóÖ»ÔËÐÐÒ»´Î.
(Ææ¹ÖµÄÊÂ,ÎÒµÄÁíÒ»¸ö±íÓà ......

mssql sql¼ò»¯

SQL code:

declare @begin datetime --¿ªÊ¼Ê±¼ä
declare @end datetime --½áÊøÊ±¼ä
declare @startIndex int --ÆðʼֵĬÈÏΪ8
declare @interval int --ʱ¶Î³¤
select @startIndex=8
select @ ......

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
uni ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ