当前位置: 动力学知识库 > 问答 > 编程问答 >

How to convert following SQL query in criteria hibernate

问题描述:

SELECT N.NATIONALITY_ID,N.CODE,N.NAME, N.BILINGUALNAME, N.ISACTIVE,

to_char(N.MODIFIED_DATE, 'YYYY-MM-DD HH24:MI:SS') as MODIFIED_DATE, U.LOGINID

FROM DBD.TBL_NATIONALITY N,DBD.TBL_USER_INFO U

WHERE N.MODIFIED_BY=U.USERID

ORDER BY N.NAME,NATIONALITY_ID

分享给朋友:
您可能感兴趣的文章:
随机阅读: