java - Way to limit one search match and no limit on others - HQL -

I have a table with flags like IorA potential value or 'I' or 'A'.

I have a hibernate query, like 'select c from myclass'.

I have to limit the records that match IOA. There is no limit on the query 'A' and 'A'. Does the union not work in HQL any other way around?

Use a subquery:

 from the  select * table where Flag = 'A' selects the union * from (select * from table * where flag = 'L' limit 3) T1