热搜
您的位置:首页 >> 娱乐

站长一些有用的sql语句实例a

2019年01月31日 栏目:娱乐

10:23 来源:互联 :水色皇朝【纠错】人评论

10:23 来源:互联 :水色皇朝【纠错】人评论

A-A+ 怎么开淘宝店 站优化方法 创业如何获得投资 小米note顶配版评测 LOL活动

1Examples

=======================================

!=(selectmax(id)e=llName=llName)

=========================================

hedulewhere

RoomID=29andStartTime''andEndTime''andRemarklike'preset'andUserID=107

and(

(ScheduleID=3177andScheduleID=3202)

or(ScheduleID=3229andScheduleID=3254)

or(ScheduleID=3307andScheduleID=3332)

=========================================

!=(selectmax(id)e=llName=llName);

==========================================

DataClient12/23/20055:03:38PM

selecttop5

DOC_RRENT_VERSION_NOasVersionDOC_DIFY_DATEasModifyDTDOC_MMARYasSummaryDOC_THOR_EMPLOYEE_NAMEasAuthorNameDOC_TLEasTitleDOC_CUMENT_TRIBUTE_TALOG_IDasCatalogIdDOC_SITE_TIMESasVisiteTimesDOC_CUMENT_IDasDocumentID2

fromDOC_MAINDOC_MAIN

InnerjoinCATALOG_SELF_ATTRIBUTEAttributeonDOC_TALOG_ID=TALOG_ID

LeftjoinDOC_STATISTICDOC_STATISTIConDOC_CUMENT_ID=DOC_CUMENT_ID

where(DOC_THOR_EMPLOYEE_ID=1)and(TRIBUTE_ID=11)

orderbyVisiteTimesDESC

====================================

selecttop1DOCUMENT_IDEMPLOYEE_NAMECOMMENT_DATECOMMENT_VALUE

C_COMMENT

whereDOCUMENT_ID=19andCOMMENT_DATE=(selectmax(COMMENT_DATE)fromDOC_COMMENTwhereDOCUMENT_ID=19)

====================================

selectTITLE(selecttop1EMPLOYEE_NAME

C_COMMENTwhereDOCUMENT_ID=19)Commentman

(selecttop1COMMENT_DATE

C_COMMENTwhereDOCUMENT_ID=19)COMMENT_DATE

fromDOC_MAINwhereDOCUMENT_ID=19

======================================

alterviewExpertDocTopComment

as

selectDOCUMENT_IDmax(ORDER_NUMBER)aslastednum

C_COMMENT

groupbyDOCUMENT_ID

go

alterviewExpertDocView

as

THOR_EMPLOYEE_PLOYEE_MENT_DATE

C_MAINa

leftjoin

ExpertDocTopCommentb

on

CUMENT_ID=CUMENT_ID

innerjoin

DOC_COMMENTc

on

CUMENT_ID=CUMENT_IDand

stednum=DER_NUMBER

======================================

ndowsUsername

01

ail

FirstNameend

LastNameend

fromUUMS_MS_Usera

leftjoin

UUMS__Employeeb

on

_EmployeeId=

=====================================

列出上传文档多的五个人的ID

selectAUTHOR_EMPLOYEE_IDcount(AUTHOR_EMPLOYEE_ID)

C_MAIN

groupbyAUTHOR_EMPLOYEE_ID

orderbycount(AUTHOR_EMPLOYEE_ID)

27192

69

1230

1116

列出上传文档多的五个人的信息

selectdistinctAUTHOR_EMPLOYEE_IDAUTHOR_EMPLOYEE_NAME

C_MAIN

whereAUTHOR_EMPLOYEE_ID

in(

selecttop5AUTHOR_EMPLOYEE_ID

C_MAIN

groupbyAUTHOR_EMPLOYEE_ID

orderbycount(AUTHOR_EMPLOYEE_ID)

)

=================================

查看更多相似文章

聚乙烯衬板
泰安蓝莓苗价格
会议专用音响设备