Hello all
Im using seam 2.0.1 and my database is Oracle 10g
I can't take distinct value from my seam generated entity
Plz guide me the code for the correct code with a example
In sql we can use
Select distinct col from table
how this can be implemented in seam..
Hi Ramesh:
A simple example is listed below.
You might want to transform the output into a List<Map> using a Hibernate transformer.
Roger.
select distinct p.attr1 as attr1, p.attr2 as attr2 from MyEntity p