sql·Ö×é²éѯÎÊÌâ - MS-SQL Server / BI
ÎÒÏÖÔÚÓÐÒ»¸ö±í£º
ÐÕÃû Åàѵ¿ªÊ¼Ê±¼ä Åàѵ½áÊøÊ±¼ä ÅàѵЧÂÊ
a 2010-05-03 00:00:00.000 2010-05-31 00:00:00.000 0.5
b 2010-05-28 00:00:00.000 2010-05-31 00:00:00.000 0.5
b 2010-05-03 00:00:00.000 2010-05-31 00:00:00.000 0.5
a 2010-05-01 00:00:00.000 2010-05-03 00:00:00.000 0.4
b 2010-06-03 00:00:00.000 2010-06-31 00:00:00.000 0.5
ÎÒÏëÒªµÄ½á¹ûÊÇ
a 2010-05-03 00:00:00.000 2010-05-31 00:00:00.000 0.5
b 2010-05-28 00:00:00.000 2010-05-31 00:00:00.000 0.5
b 2010-06-03 00:00:00.000 2010-06-31 00:00:00.000 0.5
¿ÉÊÇÕÒÁËÐí¶à·½·¨×ÜÊÇû°ì·¨½«Ô·ÝÇø·Ö¿ª£¬²éѯµÄÊý¾Ý×ÜÊǸù¾Ý×îºóÒ»ÌõËãµÄ£¬Ï£ÍûÄÜÓÐÈ˸ø½â´ðһϣ¡
2010-06-31 ????
ÊÇ30ºÅ¸Õ²Å¸Ä´íÁË
Õâ¸öÄܰïÎÒ½â¾öô£¿
SQL code:
select * from tb t where not exists (
select 1 from tb where t.ÐÕÃû=ÐÕÃû
and datediff(m,t.Åàѵ½áÊøÊ±¼ä,Åàѵ½áÊøÊ±¼ä)=0
and t.Åàѵ½áÊøÊ±¼ä>=Åàѵ½áÊøÊ±¼ä
and t.Åàѵ¿ªÊ¼Ê±¼ä>Åàѵ¿ªÊ¼Ê±¼ä
)
/*
ÐÕÃû Åàѵ¿ªÊ¼Ê±¼ä Åàѵ½áÊøÊ±¼ä ÅàѵЧÂÊ
---- ------------------------------------------------------ ------------------------------------------------------ ----
b 2010-05-03 00:00:00.000 2010-05-31 00:00:00.000 .5
a 2010-05
Ïà¹ØÎÊ´ð£º
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......
ÔSQLÓï¾äSQL code:
SELECT t6.FName '²Ù×÷¹¤',t1.FDate 'ÈÕÆÚ',t5.FName 'ÖÆµ¥ÈË',t3.FName 'É豸',t4.FName '°àÖÆ',
t7.FBillNo '¹¤ÒÕÖ¸Áîµ¥ºÅ',t8.FName '¸Úλ',t2. ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£©
emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿
b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿
c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿
d ......
ÈçºÎ´ÓÒDZíÖн«¸ù¾ÝÈÕÆÚ²éѯµÄ½á¹û°´×îÐÂʱ¼ä£¨ÏñÐÂÎÅÄÇÑù£©µÄ·½Ê½ÅÅÁгöÀ´
(²»Òª¸ß¹ÀÄãµÄººÓï±í´ïÄÜÁ¦»òÕßÎҵĺºÓïÀí½âÄÜÁ¦)
½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á ......