SQL to HQL 'start with' and 'Connect by Prior'

Question

I need to find a way to get the ids starting with 11, in sql is with 'start with' and 'Connect by prior' but in HQL, how can I do that?, if there is a better way in grails, the help would be great, thanks!

(Updated: Sorry, I didn't write the other command which is: 'connect by prior')

Do you mean something like `[offset: 10]` or `where id > 10`? — doelleri, Sep 25 '12 at 19:10
Oh. I had a third interpretation: the ID as a string starts with '11'. What exactly do you want. — JB Nizet, Sep 25 '12 at 19:19

score 4 · Answer 1 · answered Sep 25 '12 at 19:10

4

Assuming the ID is a string, why not simply use a like clause:

where id like '11%'

Assuming it's not a string, you could cast it to a string:

where cast(id as STRING) like '11%'

or

where str(id) like '11%'

answered Sep 25 '12 at 19:10

JB Nizet

678,734
91
1,224
1,255

score 0 · Answer 2 · answered Sep 25 '12 at 19:10

0

If you mean query for records with ids greater or equal to 11, then example if you have a table of Books, then the HQL would be

def books = Books.executeQuery("SELECT b from Books b WHERE id >= 11")

answered Sep 25 '12 at 19:10

ibaralf

12,218
5
47
69

score 0 · Answer 3 · edited May 23 '17 at 11:56

0

Recursive SQL queries are non-standard so HQL does not support them (although I found a paper that appears to propose and prototype adding support). To do them you'll need to stick with SQL. Here's a similar question.

edited May 23 '17 at 11:56

Community

1
1

answered Sep 25 '12 at 20:20

doelleri

19,232
5
61
65

SQL to HQL 'start with' and 'Connect by Prior'

3 Answers3