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
ÎÄÕ·ÖÀà:Java±à³Ì
ÔÚijЩ³¡ºÏÏ£¬ÎÒÃÇ¿ÉÄÜÏëʹÓÃHIBERNATEµÄ¿ò¼ÜÌṩµÄSQL²éѯ½Ó¿Ú£¬Õâʱ£¬ÓÉÓÚ±íºÍʵÌå¶¼¿ÉÄÜûÓÐ×öÓ³É䣬HIBERNATE²»Äܰѽá¹û¼¯×ª»»
³ÉÄãÏëÒªµÄList<POJO>£¬±¾ÎÄÌÖÂÛÈçºÎÔÚÕâÖÖÇé¿öÏÂÈÃHIBERNATEÖ±½Ó·µ»ØÄãÏëµÄ½ ......
¹úÍâ¿Õ¼äÃ²ËÆ¶ÔÖÐÎıȽϸÐð Èç¹ûÊý¾ÝÀàÐÍÉè¼ÆÎª varchar ÀàÐ͵ϰ ´æ´¢µÄÊý¾Ý»ù±¾ÉÏÊÇ "£¿£¿£¿£¿"
ºÜ¼òµ¥ ½« varchar ÀàÐÍ Éè¼ÆÎª nvarchar ÀàÐÍ
create table cs
(
txt1 nvarchar(50) null
)
insert into cs (txt1 ) values ('²âÊÔ') -- Èë¿âʱÊý¾Ýʱ £¿£¿£¿£¿
insert into cs (txt ......
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 ......
ÔÎĵØÖ·£ºhttp://www.dingos.cn/index.php?topic=1688.0
OracleÓÐrownumÓÃÓÚ·ÃÎʱíÖÐÐкš£ÄÇôÔÚSQL ServerÖÐÊÇ·ñÓеÈЧµÄÄØ£¿»òÕßÔÚSQL ServerÖÐÈçºÎÊä³öÐкţ¿
-----------------------------------
ÔÚSQL ServerÖÐûÓÐÖ±½ÓµÈЧÓÚOracleµÄrownum
-----------------------------------
Ñϸñ˵À´£¬ÔÚ¹ØÏµÊý¾Ý¿âÖУ ......
--ÐÐÁл¥×ª
/******************************************************************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶®
ÕûÀíÈË£ºÖйú·ç(Roy)
ÈÕÆÚ:2008.06.06
***************************************************************** ......