Hibernate Community • View topic - select distinct for two field in same table

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

select distinct for two field in same table

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

praveen.sule

Post subject: select distinct for two field in same table

Posted: Wed Feb 02, 2011 7:48 am

Newbie

Joined: Wed Feb 02, 2011 7:14 am
Posts: 1

hi i am new to hibernate i have a doubt, i want to write a query to

Quote:

select distinct first name and last name from a table

table student
id first_name last_name
1 Praveen Sule
2 Praveen Kumar
3 Praveen Sule

i want an output as a list of 1&2

can any plz guide me.

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum