| What do you need for ? |
|
Grade :
Category :
|
|
| Choose and Click to change topic |
| |
|
SELECT S_CI_NAME,GUID,B.DATA_USED,B.DATE_ATTR2 FROM SOS_CUBE_ITEM A LEFT OUTER JOIN (SELECT DATA_USED,LINK_ATTR1,DATE_ATTR2 FROM SOS_CLASSROOM_DATA WHERE S_CL_NO='' and s_m_user_no='') B ON A.GUID=B.link_attr1 WHERE UPID IN ( SELECT GUID FROM SOS_CUBE_ITEM WHERE UPID LIKE '%' ) AND SUBSTRING(UPID,1,5) IN( SELECT GUID FROM SOS_CUBE_ITEM WHERE LV = 3 AND SUBSTRING(GUID,1,1) =1 AND S_CI_NAME = 'MATH' ) AND S_CI_TYPE = 'TOP' AND S_CATEGORY IS NOT NULL AND LEFT(S_CATEGORY,2) = '' ORDER BY S_CI_NAME
|
|
|
| |
|
|
|