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

sql case select

SELECT ID,TITLE,
(SELECT TIMES from CLS_COURSE WHERE CLS_COURSE.ID=CLS_CLASS.COURSEID) AS TIMES,
(SELECT CASE WHEN EXISTS(SELECT *  from CLS_ATDC WHERE CLS_ATDC.CLSID=CLS_CLASS.ID ) THEN (SELECT TOP 1 COURSETIME from CLS_ATDC WHERE CLS_ATDC.CLSID=CLS_CLASS.ID ORDER BY COURSETIME DESC) ELSE 0 END) AS CURRENTCOURSETIME
from CLS_CLASS WHERE DEPTID=@DEPTID AND ID IN (SELECT CLSID from CLS_DETAIL WHERE CLSDATE>=@BEGIN AND CLSDATE<=@END)


Ïà¹ØÎĵµ£º

ʹÓÃHIBERNATEµÄSQL²éѯ²¢½«½á¹û¼¯×Ô¶¯×ª»»³ÉPOJO

ʹÓÃHIBERNATEµÄSQL²éѯ²¢½«½á¹û¼¯×Ô¶¯×ª»»³ÉPOJO
ÎÄÕ·ÖÀà:Java±à³Ì



ÔÚijЩ³¡ºÏÏ£¬ÎÒÃÇ¿ÉÄÜÏëʹÓÃHIBERNATEµÄ¿ò¼ÜÌṩµÄSQL²éѯ½Ó¿Ú£¬Õâʱ£¬ÓÉÓÚ±íºÍʵÌå¶¼¿ÉÄÜûÓÐ×öÓ³É䣬HIBERNATE²»Äܰѽá¹û¼¯×ª»»
³ÉÄãÏëÒªµÄList<POJO>£¬±¾ÎÄÌÖÂÛÈçºÎÔÚÕâÖÖÇé¿öÏÂÈÃHIBERNATEÖ±½Ó·µ»ØÄãÏëµÄ½ ......

¹úÍâ¿Õ¼äSqlÊý¾ÝÂÒÂëÎÊÌâ

¹úÍâ¿Õ¼äÃ²ËÆ¶ÔÖÐÎıȽϸÐð Èç¹ûÊý¾ÝÀàÐÍÉè¼ÆÎª varchar ÀàÐ͵ϰ ´æ´¢µÄÊý¾Ý»ù±¾ÉÏÊÇ  "£¿£¿£¿£¿"
ºÜ¼òµ¥ ½« varchar ÀàÐÍ Éè¼ÆÎª nvarchar ÀàÐÍ
create table cs
(
   txt1 nvarchar(50) null
)
insert into cs (txt1 ) values ('²âÊÔ')  -- Èë¿âʱÊý¾Ýʱ £¿£¿£¿£¿
insert into cs (txt ......

sqlÓï¾ä¼¯ºÏ

A¡£
SQLÓï¾äµÄ²¢¼¯UNION£¬½»¼¯JOIN(ÄÚÁ¬½Ó£¬ÍâÁ¬½Ó)£¬½»²æÁ¬½Ó(CROSS
JOINµÑ¿¨¶û»ý)£¬²î¼¯(NOT IN)
1.
a. ²¢¼¯UNION
SELECT column1, column2 from table1
UNION
SELECT column1, column2 from table2
b. ½»¼¯JOIN
SELECT * from table1 AS a JOIN table2 b ON a.name=b.name
c. ²î¼¯NOT IN
SELECT * from tabl ......

ÔÚSQL ServerÖÐÈçºÎÊä³öÐкÅ


Ô­ÎĵØÖ·£ºhttp://www.dingos.cn/index.php?topic=1688.0
OracleÓÐrownumÓÃÓÚ·ÃÎʱíÖÐÐкš£ÄÇôÔÚSQL ServerÖÐÊÇ·ñÓеÈЧµÄÄØ£¿»òÕßÔÚSQL ServerÖÐÈçºÎÊä³öÐкţ¿
-----------------------------------
ÔÚSQL ServerÖÐûÓÐÖ±½ÓµÈЧÓÚOracleµÄrownum
-----------------------------------
Ñϸñ˵À´£¬ÔÚ¹ØÏµÊý¾Ý¿âÖУ ......

sqlÐÐÁл¥×ª(תÌû)

--ÐÐÁл¥×ª
/******************************************************************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶®
ÕûÀíÈË£ºÖйú·ç(Roy)
ÈÕÆÚ:2008.06.06
***************************************************************** ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ