Hi all,

Does anybody know how to convert following sql into hql

SELECT thread_id
, subject
, id
FROM
(
SELECT thread_id
, subject
, id
, ROW_NUMBER () OVER ( PARTITION BY thread_id ORDER BY id )
AS thread_id_Row_Number

FROM TEST_SHRINK
)
WHERE thread_id_Row_Number = 1
;

Here is my table:
CREATE TABLE TEST_SHRINK
( thread_id NUMBER
, subject VARCHAR2 ( 128 )
, id VARCHAR2 ( 128 )
);

Thanks in advance.

-Stan